search range in workbook 2 for matching value from column in workbook 1 then copy row

i have 2 workbooks; we'll call them 1 and 2.

workbook 1, column A, has usernames: each one unique, all alpha numeric combinations.

workbook 2 has several columns (range) which contain SOME (not all) of the values from workbook 1, column A.

I would like to search the range in workbook 2 for matching values from column A workbook 1.

when a match is found in workbook 2, then copy that entire row from workbook 2 where the match occurred to another worksheet or workbook (either is fine)

can someone please help me with an elegant way to perform this?

The destination: A single sheet for all matches, or a different sheet for each match?

Originally Posted by leelnich

The destination: A single sheet for all matches, or a different sheet for each match?

A Single sheet.thanks!

i get a 'run time error 9' subscript out of range on this line;

Set WS3 = Workbooks("workbook3").Worksheets("Sheet1")

i believe my ranges and names are correct.

Hi !

Around ten codelines just using an easy advanced filter …

Hi got it working thank you. The way it is currently, you have to create 'workbook3' and make sure it is OPEN....or it breaks. THANK YOU for your help!!

Happy to help. If you're satisfied with this solution, please go to your original post, select Thread Tools, and mark this thread as SOLVED. Thanks-Lee

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

done. -best