Right guys need a way to do the following.....
I have several folders that contain workbooks with Jan to dec sheets.
i need to copy cells z5 to z10 (maybe individually) in each workbook in each worksheet and total the sum and paste it to a new workbook.
So, it needs to jump into a certain Location that contains workbooks, total z5 for january worksheet then sum it to c4 january worksheet in master workbook.
then reapeat for z6, z7, z8, z9, z10 to master c5, c6, c7, c8, c9
and then for Febuary, march etc to december.
If i get the code for january z5:10 then i'm sure i could amend for all the rest of the months, i guess this maybe simpler.
Hope its clear enough for you wizards.
Many thanks in help with this.
Ian Wells
I have several folders that contain workbooks with Jan to dec sheets.
i need to copy cells z5 to z10 (maybe individually) in each workbook in each worksheet and total the sum and paste it to a new workbook.
So, it needs to jump into a certain Location that contains workbooks, total z5 for january worksheet then sum it to c4 january worksheet in master workbook.
then reapeat for z6, z7, z8, z9, z10 to master c5, c6, c7, c8, c9
and then for Febuary, march etc to december.
If i get the code for january z5:10 then i'm sure i could amend for all the rest of the months, i guess this maybe simpler.
Hope its clear enough for you wizards.
Many thanks in help with this.
Ian Wells