How to Copy data range from multiple sheets to existing sheets on a different workbook?

[jabonza]

Hello, I am new to Excel VBA. I have 2 different excel files and have Sheets from the first file which need to be transferred to other Sheets on the second file. The origin and the destination of the sheets will change for each loop as they are filled. (See example below)

The copy needs to follow a sequence similar to this:

Workbook 1 Sheet 1 to Workbook 2 Sheet 1
Workbook 1 Sheet 2 to Workbook 2 Sheet 2
Workbook 1 Sheet 3 to Workbook 2 Sheet 3
and so on and so forth until all worksheets have been copied.

Any help would be greatly appreciated. Please let me know if you have any questions. Thank you

 

[Marc L]

Hello,​

​

in case the second workbook must be an exact copy of the first workbook​

then the smart way is to just save the first workbook as a copy with the full path name of the second which must be closed …​

 

[jabonza]

Hello,​

​

in case the second workbook must be an exact copy of the first workbook​

then the smart way is to just save the first workbook as a copy with the full path name of the second which must be closed …​

Thanks for the reply.

I have around 100+ sheets that would need to be copied. Is there a way I can automatically embed a formula into the cells without manually typing it in for each sheet?