Prevent/Restrict duplicates in multiple sheets

Copper Contributor

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?

1 Reply

It's unfortunate there's not a response to this question. I have the same issue and was hoping someone had already figured this one out.