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
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