Hi all,

I'm new here so please forgive me if I don't provide you with enough info, I'll try my best!

Ok, so I need some assistance please - I have a workbook with two sheets currently. Sheet 1 contains hundreds of rows complete with personal data having been logged onto a service desk type system, column A being the individuals name. Sheet 2 contains a list of 70 names in column A; those are the people I'm interested in - but they are not the only people to have information on the system.

What I'm looking to achieve is to cross reference Sheet 2 Column A with Sheet 1 Column A and copy the entire row onto a new sheet where they both match. I have searched this and the answers found assume only one match will be found; in this instance they could be multiple matches for the individual named in Sheet 2 Column 1, I need all rows for that match copied, before excel moves onto looking for the next individual.

Hope that makes sense - any guidance would be much appreciated as I'm struggling to work this out.

Thanks in advance,