Hi
I am hoping someone can help.
I have 10 workbooks (for this purpose named a, b, c, e, f etc...), each have 3 tabs. I wanted a Master sheet to open each workbook in turn and paste the information onto a corresponding tab I.e. Workbook "a" would open and copy information from Tab "Info" (rows 1-1000) into the Master workbook Tab "A", then move onto Workbook "b" and do the same action and copy the information into the Master workbook Tab "B".
The Master will be saved in the same folder.
Hope you are able to help.
Many thanks
MarkAn
I am hoping someone can help.
I have 10 workbooks (for this purpose named a, b, c, e, f etc...), each have 3 tabs. I wanted a Master sheet to open each workbook in turn and paste the information onto a corresponding tab I.e. Workbook "a" would open and copy information from Tab "Info" (rows 1-1000) into the Master workbook Tab "A", then move onto Workbook "b" and do the same action and copy the information into the Master workbook Tab "B".
The Master will be saved in the same folder.
Hope you are able to help.
Many thanks
MarkAn