First post so let me know if I don't give enough info.
I've searched the forums for something close to what I'm after and can't find anything which goes into the detail that I need. I'm not massively experienced in using VBA so please keep that in mind.
Basically I have a number of Workbooks, roughly 8, and each of those Workbooks has a summary Worksheet, then a separate Worksheet for each month of the year (January - December).
What I need to do is copy of all the information from the January Worksheet in each Workbook into the master work book, then do the same for February, March etc etc. There isn't a set number of entries for each Worksheet, so for example the first Workbook could have 5 rows of date for Jan, the next Workbook might have nothing, the next one might have 6. I need it so it simply copies everything in Workbook 1 January, then Workbook 2 January etc etc, all the way through until Workbook 8 December.
This info needs to be copied into a master spreadsheet which has the same format, i.e. summary sheet and months of the year. The summary sheet on the master spreadsheet is compiled from the information in the Months worksheets on the master spreadsheet.
The range of the data isn't fixed so the macro will need someway to work out what the last row of data is. The entire line of data will need copied and it starts from A3 and goes to AU3.
All of the 8 Workbooks are stored in the same folder on a network drive, the master spreadsheet is currently stored on my desktop but will eventually be going on Sharepoint at some point in the future.
Hopefully I've explain everything, and if anyone could help it would be greatly appreciated.
Thanks
Steeeve
I've searched the forums for something close to what I'm after and can't find anything which goes into the detail that I need. I'm not massively experienced in using VBA so please keep that in mind.
Basically I have a number of Workbooks, roughly 8, and each of those Workbooks has a summary Worksheet, then a separate Worksheet for each month of the year (January - December).
What I need to do is copy of all the information from the January Worksheet in each Workbook into the master work book, then do the same for February, March etc etc. There isn't a set number of entries for each Worksheet, so for example the first Workbook could have 5 rows of date for Jan, the next Workbook might have nothing, the next one might have 6. I need it so it simply copies everything in Workbook 1 January, then Workbook 2 January etc etc, all the way through until Workbook 8 December.
This info needs to be copied into a master spreadsheet which has the same format, i.e. summary sheet and months of the year. The summary sheet on the master spreadsheet is compiled from the information in the Months worksheets on the master spreadsheet.
The range of the data isn't fixed so the macro will need someway to work out what the last row of data is. The entire line of data will need copied and it starts from A3 and goes to AU3.
All of the 8 Workbooks are stored in the same folder on a network drive, the master spreadsheet is currently stored on my desktop but will eventually be going on Sharepoint at some point in the future.
Hopefully I've explain everything, and if anyone could help it would be greatly appreciated.
Thanks
Steeeve
