I have 3 sheet, named master sheet, sheet1 and sheet2.
My master sheet contain a full list. sheet1 contain part of the list from master sheet, same as sheet2. I want to make sure list in sheet1 and sheet2 is complete, which it include everything in the master sheet and nothing is mising. How can I do this?
Assume it's column C is all 3 sheets.
Thanks.
My master sheet contain a full list. sheet1 contain part of the list from master sheet, same as sheet2. I want to make sure list in sheet1 and sheet2 is complete, which it include everything in the master sheet and nothing is mising. How can I do this?
Assume it's column C is all 3 sheets.
Thanks.