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.
|