Increment data when importing

So the code that I have done is working importing a specific range of values and pasting perfectly in the target folder.

But in my company there exists a need to import the data from that file but to always increment. For example: the file where I extract the data is from week 1 and the info is in the main file but next week the file from week 2 is out and needs to be imported when I import the data it pastes the data over the old one.

But the problem is that I also need to keep the old data in the main file too. So It should increment down below. to demonstrate this I will use some numbers.

Data Imported from first week source workbook: 1,1,1,1
Data pasted In target workbook: 1,1,1,1

Data Imported from second week source workbook: 2,2,2,2
Data Pasted in target workbook: 2,2,2,2

Result wanted data imported from both source WB to target WB: 1,1,1,1,2,2,2,2

Please Login or Register  to view this content.

Can you try adding the code in my existing code.