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.

Checking items across worksheets
 

one thing I can think of is programming a small piece vba and make a macro
that checks if your serial numbers in the master sheets are present in the
other sheets. But maybe there is a more direct method.

rh


"jpreman" wrote:

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.