View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Judy Judy is offline
external usenet poster
 
Posts: 53
Default how do i see which data matches between two worksheets?

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.