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.

how do i see which data matches between two worksheets?
 

Hi,
look CPearson web

http://www.cpearson.com/excel/ListFunctions.aspx

second title Extracting Elements Common To Two Lists



"Judy" wrote:

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.