Hi all,
I have a workbook with a worksheet ("work1") with names in Column A and serial numbers in Column B.
In this workbook is a second worksheet ("work2") with another list of serial numbers.
I need the macro to look for serial numbers in work1 (column B) from work2.
If cell is found, cut row out of work1 and paste in new worksheet.
Thanks!
Bookmarks