View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jpreman jpreman is offline
external usenet poster
 
Posts: 50
Default Checking items across worksheets

Thanks for reading this post.

I have a list of say 100 items with serial numberes in a Master sheet. These
items, based on different criteria appear, along with the serial numbers,over
several worksheets (in the same file). I would like to check if there are
any item from the Master sheet that does not appear in any of the other
sheets. How can I achieve this?
Note : the serial numbers are in the identical columns in all the sheets.