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?