Mar 14 2022 07:25 AM
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?
Sep 27 2023 09:29 AM
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.