how do i see which data matches between two worksheets?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Absolute References and worksheets 0
Lookup and return value 8
Linking data between spreadsheets 2
synchronization ? 1
Combining data from multiple worksheets. 7
listing data without blank rows 17
if student number repeats move all data for that number on to same 1
Compare and then copy cell to separate worksheet 1

Top