How can I compare worksheets in the same workbook?
 

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.

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 he
http://www.cpearson.com/excel/duplic...tingDuplicates

--
Gordon Burgess-Parker
Interim Systems and Management Accounting
www.gbpcomputing.co.uk

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

"Gordon" wrote:

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 he
http://www.cpearson.com/excel/duplic...tingDuplicates

--
Gordon Burgess-Parker
Interim Systems and Management Accounting
www.gbpcomputing.co.uk