[QUOTE=Mooseman60;3180827]Hi I am using Excel 2003 and have 27 different workbooks in the same folder in My Documents and would like to know how i can create a Macro to copy the same cells from each of the 27 workbooks to one new summary workbook. All the data is in the same cell numbers in all 27 workbooks.
Eg: The following summary workbook cells to save data too are A3, B3, C3, E3, F3
The cells from the 27 workbooks are E19, L10, L9, L15+L16
So A3 = E19 B3 = L10 C3 = L9 E3 = L17 F3 = L15+L16
I hope this makes sense See attached worksheet I have also posted this on Mr Excel but with no one able to help.
Building Q1 Total Q1 GM Workbook Q2 Total Q2 GM
E19 L10 L9 1 L17 L15+L16
E19 L10 L9 2 L17 L15+L16
E19 L10 L9 3 L17 L15+L16
E19 L10 L9 4 L17 L15+L16
E19 L10 L9 5 L17 L15+L16
E19 L10 L9 6 L17 L15+L16
E19 L10 L9 7 L17 L15+L16
E19 L10 L9 8 L17 L15+L16
E19 L10 L9 9 L17 L15+L16
E19 L10 L9 10 L17 L15+L16
E19 L10 L9 11 L17 L15+L16
E19 L10 L9 12 L17 L15+L16
E19 L10 L9 13 L17 L15+L16
E19 L10 L9 14 L17 L15+L16
E19 L10 L9 15 L17 L15+L16
E19 L10 L9 16 L17 L15+L16
E19 L10 L9 17 L17 L15+L16
E19 L10 L9 18 L17 L15+L16
E19 L10 L9 19 L17 L15+L16
E19 L10 L9 20 L17 L15+L16
E19 L10 L9 21 L17 L15+L16
E19 L10 L9 22 L17 L15+L16
E19 L10 L9 23 L17 L15+L16
E19 L10 L9 24 L17 L15+L16
E19 L10 L9 25 L17 L15+L16
E19 L10 L9 26 L17 L15+L16
E19 L10 L9 27 L17 L15+L16
Bookmarks