Import information from excel dokument and sort it by date

[lababa]

Hi,

I have twoexcel documents, "Book1" and "Book2". Book1 is exportedfrom our business system. Book2 is a compilation of forecast from the businesssystem data that were exported.

Today Ihave to manually put in the data from Book1 to Book2. I want to put a VBA Codein Book2 to import data from Book1 and automate that process.

In Book2 Ihave dates in row 25 like dec-18, jan-19, feb-19 and so on. I want these datesto be matched with the dates in Book1 that are displayed as 2019-01-05 and soon, which are displayed vertically in column S. I want the row 25 in Book2 to goto Book1 and match the dates, and if it gets a match I want it to put the datafrom Book1 column R associated with that date in same row, in the columnassociated with that date on Book2. Could someone help me do this ?
For example Book2matches jan-19 with 2019-01-05 and imports 4.414.992 to row 30 in Book2.

 

[lababa]

Images:
Book1: https://framapic.org/EdCfiEnwNE3G/xi0yGTaWM33i.PNG
Book 2(Where I want to import data to): https://framapic.org/3RciFks0qJBE/s3t48R3Ncna9.PNG

 

[lababa]

For example Book2matches jan-19 with 2019-01-05 and imports 6.414.992 to row 30 in Book2, not 4.414.992