Hi there,
I have 5 excel documents, each containing 1 worksheet that lists a set of information relating to a serial number like in the table below. In each of the documents the list of the serial numbers is the same, but the properties are different e.g. Document 1 contains property A, B, C Document 2 contains property D, E, F. etc.
<tbody>
</tbody>
What I'm trying to do is combine all the documents into 1 summary worksheet that contains all the data listed against each serial number so it looks something like the second table: In the past I've used VLOOKUP for completing a similar process where all the data is in one document but I don't really know where to start when trying to combine multiple documents, any help would be much appreciated.
<tbody>
</tbody>
I have 5 excel documents, each containing 1 worksheet that lists a set of information relating to a serial number like in the table below. In each of the documents the list of the serial numbers is the same, but the properties are different e.g. Document 1 contains property A, B, C Document 2 contains property D, E, F. etc.
| Serial Number | Property A | Property B | Property C |
| 1234 | 10 | 15 | 8 |
| 4768 | 123 | 3 | 24 |
<tbody>
</tbody>
What I'm trying to do is combine all the documents into 1 summary worksheet that contains all the data listed against each serial number so it looks something like the second table: In the past I've used VLOOKUP for completing a similar process where all the data is in one document but I don't really know where to start when trying to combine multiple documents, any help would be much appreciated.
| Serial Number | Property A | Property B | Property C | Property D | Property E | Property F |
| 1234 | 10 | 15 | 8 | 2 | 5 | 3 |
| 4768 | 123 | 3 | 24 | 2 | 43 | 7 |
<tbody>
</tbody>
