Export and sort data depending on dates from one book to another.

Hi,
I have two excel documents, "Book1" and "Book2". Book1 is exported from our business system. Book2 is a compilation of forecast from the business system 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 6.414.992 should automaticly be input in jan-19 in Book2 row 29(yellow field). Could someone help me do this

Perhab

Please Login or Register  to view this content.

Originally Posted by lababa

Hi,

Thank you for your answer. I pasted the code in a Module in excel, it says subscript out of range and highlights "Set wb2 = Workbooks("Book2.xls")". I changed some of the code. The worksheet I'm trying to paste the code in is Sheet2. The workbook I try to export data from is Book2.xls. Both of the files are on the desktop.

Please Login or Register  to view this content.

Perhab wrong your sheet.name
Or range position
You can check using msgbox
And both workbook must to open

Hi, It now says "Run-time error '1004': No cells were found." and highlights "For Each r In ws1.Columns("s").SpecialCells(2).Cells"
As I described earlier I would like to paste this code in the same sheet as I want to import information to. So I want this sheet to import information from Book2.xls. Sorry if i confused you

Correct me if I'm wrong, but I think this codes takes info from the sheet I paste the code in.