lababa
11-27-2018, 02:20 AM
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, it's driving me crazy 😊
Thank you in advance!
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, it's driving me crazy 😊
Thank you in advance!