View Single Post
  #1   Report Post  
Malcolm M
 
Posts: n/a
Default 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.