From: Judy on
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.
From: Eduardo on
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.