Forum Discussion
Prevent/Restrict duplicates in multiple sheets
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.
