how do i see which data matches between two worksheets?

  • Thread starter Thread starter Judy
  • Start date Start date
J

Judy

I need to compare a very long worksheet (W1) to a shorter worksheet (W2) to
see if any of the files listed on W1 are on W2. I then need to copy the
matching rows from W2 to a new worksheet.
 
Back
Top