Match two rows of different sheets and copy to new sheet

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,

Try this macro:

Please Login or Register  to view this content.

Thank you - it works in that it copies those names to a new sheet, but it doesn't copy the entire row for that person - how do I change this?

Actually it doesn't seem to extract the correct individuals, but any individual?

Thanks Ollie - though Dubugger doesn't like the following?

pvt_obj_Recordset.Open pvt_str_Query, pvt_obj_Connection, adOpenDynamic, adLockReadOnly

Any ideas?

Millz - your time to assist me is extremely appreciated - thank you so much. Your macro worked a treat!