Prevent/Restrict duplicates in multiple sheets

Occasional Visitor

I work for a grain company that uses an excel spreadsheet to track the commodities in all of our Bins. This spreadsheet has 25-30 sheets within the workbook. As product comes in or moved out we have to move the bins from one sheet to another depending on the commodity. I have found where whomever moved the bin neglected to delete it from the previous sheet. 

 

How do I prevent/restrict duplicate bin numbers in ALL the sheets within the workbook?

0 Replies