I have multiple workbooks that are very similar. One table per workbook, identical column headings on all, each workbook has rows added daily.
I need to combine each table from all workbooks into one master table so I can analyze them together. Is there a formula to set this up, or perhaps a VBA script that will combine it instead of copy and pasting tables together? Example is below...
First table/workbook:
<tbody>
</tbody>
Second table/workbook:
<tbody>
</tbody>
This is the combined output I need to produce into a new workbook:
<tbody>
</tbody>
I need to combine each table from all workbooks into one master table so I can analyze them together. Is there a formula to set this up, or perhaps a VBA script that will combine it instead of copy and pasting tables together? Example is below...
First table/workbook:
Ticket | Job | Hours |
B | job 1 | 5 |
B | job 2 | 5 |
B | job 3 | 5 |
<tbody>
</tbody>
Second table/workbook:
Ticket | Job | Hours |
A | job 1 | 3 |
A | job 2 | 3 |
<tbody>
</tbody>
This is the combined output I need to produce into a new workbook:
Ticket | Job | Hours |
B | job 1 | 5 |
B | job 2 | 5 |
B | job 3 | 5 |
A | job 1 | 3 |
A | job 2 | 3 |
<tbody>
</tbody>