Hello,
I'm having five workbooks called like this:
R83_COM1.xlsx
R83_COM2.xlsx
R83_COM3.xlsx
R83_COM4.xlsx
R83_COM5.xlsx
Each workbook has three sheets, which have the same names:
ComSheet1, ComSheet2, ComSheet3
I've created a workbook called R83_ALL.xlsx with the following sheets:
COM1, COM2, COM3, COM4 and COM5
Now I want to copy the "ComSheet2" sheet from the five workbooks to R83_ALL as follows:
"ComSheet2" from R83_COM1.xlsx to sheet "COM1" in R83_ALL.xlsx
"ComSheet2" from R83_COM2.xlsx to sheet "COM2" in R83_ALL.xlsx
"ComSheet2" from R83_COM3.xlsx to sheet "COM3" in R83_ALL.xlsx
"ComSheet2" from R83_COM4.xlsx to sheet "COM4" in R83_ALL.xlsx
"ComSheet2" from R83_COM5.xlsx to sheet "COM5" in R83_ALL.xlsx
Do you know an easy to program this?
Thank you very much for your help!
Bookmarks