I have a Master sheet that contains products. There are approx 800 lines in this sheet.
I also have 2 other sheets that are basically subsheets of the Master. The California product list has about 400 products in it, the Nevada one approx 500.
As a business rule any product in one of the sublists MUST exist in the master list. I am trying to find an easy way to compare the sub list to the master list so I can make that one of the sublists did not get a product added to them that hasnt been added to the master list.
Can you think of anything in Excel or maybe a third party product that might help
I also have 2 other sheets that are basically subsheets of the Master. The California product list has about 400 products in it, the Nevada one approx 500.
As a business rule any product in one of the sublists MUST exist in the master list. I am trying to find an easy way to compare the sub list to the master list so I can make that one of the sublists did not get a product added to them that hasnt been added to the master list.
Can you think of anything in Excel or maybe a third party product that might help