Hi,
I have two excel documents, "Book1" and "Book2". Book1 is exported from our business system. Book2 is a compilation of forecast from the businesssystem data that were exported.
Today I have to manually put in the data from Book1 to Book2. I want to put a VBA Code in Book2 to import data from Book1 and automate that process.
In Book2 I have dates in row 25 like dec-18, jan-19, feb-19 and so on. I want these dates to be matched with the dates in Book1 that are displayed as 2019-01-05 and so on, which are displayed vertically in column S. I want the row 25 in Book2 to go to Book1 and match the dates, and if it gets a match I want it to put the data from Book1 column R associated with that date in same row, in the column associated with that date on Book2. Could someone help me do this ?
For example Book2matches jan-19 with 2019-01-05 and imports 6.414.992 to row 30 in Book2.
Book1: https://framapic.org/EdCfiEnwNE3G/xi0yGTaWM33i.PNG
Book2: https://framapic.org/3RciFks0qJBE/s3t48R3Ncna9.PNG
I have two excel documents, "Book1" and "Book2". Book1 is exported from our business system. Book2 is a compilation of forecast from the businesssystem data that were exported.
Today I have to manually put in the data from Book1 to Book2. I want to put a VBA Code in Book2 to import data from Book1 and automate that process.
In Book2 I have dates in row 25 like dec-18, jan-19, feb-19 and so on. I want these dates to be matched with the dates in Book1 that are displayed as 2019-01-05 and so on, which are displayed vertically in column S. I want the row 25 in Book2 to go to Book1 and match the dates, and if it gets a match I want it to put the data from Book1 column R associated with that date in same row, in the column associated with that date on Book2. Could someone help me do this ?
For example Book2matches jan-19 with 2019-01-05 and imports 6.414.992 to row 30 in Book2.
Book1: https://framapic.org/EdCfiEnwNE3G/xi0yGTaWM33i.PNG
Book2: https://framapic.org/3RciFks0qJBE/s3t48R3Ncna9.PNG
