Creating sheet based on comparison of two others

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
 
Back
Top