excelusercr
New Member
- Joined
- Jan 22, 2007
- Messages
- 4
I currently have to consolidate data from multiple workbooks into a single file. The format of the data is the same and each workbook has the data already selected. Is there a way to automate this using a macro?
I am envisioning the following...
1) Summaryworkbook.summaryWorksheet - this would contain the consolidated data
2) Workbook1.Worksheet1 - worksheet1 would have the data needing to be copied already selected. The macro would need to open this file and then copy the selected data from worksheet1 and paste it to Summaryworkbook.summaryWorksheet, then close this workbook
3) Workbook2.Worksheet2 - worksheet2 would have the data needing to be copied already selected. The macro would need to open this file and then copy the selected data from worksheet1 and paste it to Summaryworkbook.summaryWorksheet, then close this workbook
4) Workbook3.Worksheet3 - worksheet3 would have the data needing to be copied already selected. The macro would need to open this file and then copy the selected data from worksheet1 and paste it to Summaryworkbook.summaryWorksheet, then close this workbook
Any help would be greatly appreciated
I am envisioning the following...
1) Summaryworkbook.summaryWorksheet - this would contain the consolidated data
2) Workbook1.Worksheet1 - worksheet1 would have the data needing to be copied already selected. The macro would need to open this file and then copy the selected data from worksheet1 and paste it to Summaryworkbook.summaryWorksheet, then close this workbook
3) Workbook2.Worksheet2 - worksheet2 would have the data needing to be copied already selected. The macro would need to open this file and then copy the selected data from worksheet1 and paste it to Summaryworkbook.summaryWorksheet, then close this workbook
4) Workbook3.Worksheet3 - worksheet3 would have the data needing to be copied already selected. The macro would need to open this file and then copy the selected data from worksheet1 and paste it to Summaryworkbook.summaryWorksheet, then close this workbook
Any help would be greatly appreciated