Hi
I have the following:
A workbook with the sheet names: P1, P2, P3 etc.
A folder with files called P1, P2, P3 etc. Each of the files contain a sheet looking like this:
untitled2.jpg
Now i need for excel to look i the folder for the file P1, open and copy from B12:E36 and H12:K36, to the sheet in the master workbook named P1. The same for P2, P3 and etc.
Anyone with a good idea?
Thanks in advance!
Regards
Niels
Bookmarks