Greetings,
I have three workbooks, containing a similar sheet.
I need to copy a certain range from two workbooks into the third one.
The sheet looks like a calendar, and I fill data in the corresponding cells.
Capture.PNG
I have a macro that copies the data from both workbooks, but the way I'm doing it, the 2nd workbook is copying above the data of the first.
The 1st workbook has data from beginning of month til Today().
The 2nd workbook has data starting from tomorrow.
Macro from 1st workbook:
Macro from 2nd workbook:
You can see that Range("G5:NR400") from 2nd workbook is copying above Range("G5:AK400") from 1st workbook...
How can I alter the copy range code in a way so that:
- from the 1st workbook, the range starts from G5 and ends with the column related to Today()
- from the 2nd workbook, the range starts from Today() + 1 till NR400.
Thanks in advance...
This question is cross-posted in the following forums:
https://www.mrexcel.com/forum/excel-...workbooks.html
http://www.excelguru.ca/forums/showt...ween-workbooks
http://www.msofficeforums.com/excel-...tml#post109960
Bookmarks