tomhawking
New member
- Joined
- Nov 7, 2012
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hi
I have a huge sheet of data which I want to cross reference with another, and if there are matches in an unique identifier, I want to copy all rows that match from the first sheet into a third. For example:
Sheet 1 would contain a load of data in rows, with the cells in column A being unique identifiers, e.g. A, B, C, D and E
Sheet 2 would have a load of data I don't care about, but the same unique identifiers, say B, D and E.
I would then like Excel to create a sheet where, in this example, the rows from sheet 1 with the unique identifiers B, D and E (i.e. those that are also present in sheet 2) are copied across.
Any help is greatly appreciated.
Thanks
Tom
I have a huge sheet of data which I want to cross reference with another, and if there are matches in an unique identifier, I want to copy all rows that match from the first sheet into a third. For example:
Sheet 1 would contain a load of data in rows, with the cells in column A being unique identifiers, e.g. A, B, C, D and E
Sheet 2 would have a load of data I don't care about, but the same unique identifiers, say B, D and E.
I would then like Excel to create a sheet where, in this example, the rows from sheet 1 with the unique identifiers B, D and E (i.e. those that are also present in sheet 2) are copied across.
Any help is greatly appreciated.
Thanks
Tom