How can I compare worksheets in the same workbook?

G

Guest

I have two storerooms in the same workbook (separate worksheets) and need to
find shared items that have different item numbers (the column names in each
sheet match.) I can use the FIND function to locate individual shared items
in both storerooms, but with over 4,000 items, I'm hoping for a faster
method.
 
G

Gordon

Malcolm M wrote:
|| I have two storerooms in the same workbook (separate worksheets) and
|| need to find shared items that have different item numbers (the
|| column names in each sheet match.) I can use the FIND function to
|| locate individual shared items in both storerooms, but with over
|| 4,000 items, I'm hoping for a faster method.

Have a look here:
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates
 
G

Guest

Thank you. I think it is just what I need. I'm not exactly a whiz at Excel,
but your suggestion looks self-explanatory.
 

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

Compare 2 worksheets 1
how can I combine multiple worksheets into a single workbook? 5
Compare worksheets 4
Linking worksheets in the same workbook by names not cells 1
compare 2 columns of numbers and place the matched numbers in a 3r 5
change links to a different source in the same workbook 2
Compare data from two different worksheets with a condition 2
Import Multiple CSV Files from Same Folder into Open Workbook 5

Top