I have two Excel workbooks with multiple tabs in each (the template layout in each tab is identical).
First, I would like to extract specific data starting with tabs AFTER the tab "MonthlySummary". Specific data wanted: Customer, Engineering Total, Equipment, Rate, Days, Total Revenue ($), and the Date. Then, arrange the extracted data into a table with headers from which, later, if you wanted to, could create pivot table/chart. This kind of table would be created in EACH workbook.
Then, I would like to create a Master Workbook where I have two buttons with macros attached. One button would say "Load Data". This macro would enable you to browse for the file with the two workbooks, select that file and pull out the table created in the first step for each workbook. The two tables pulled out would show up as tabs in the Master Workbook.
The second button would say "Consolidate Data". This macro would enable you to consolidate the two tables into one MasterTable from which you could also create a pivot table.
Attached are two examples of the individual workbooks from which I want to extract data in order to consolidate it.
test_workbook1.xlstes_workbook2.xls
If anyone could help with ANY of these steps, it would help me a great lot! Thank you in advance.
Bookmarks