katiapro93
Board Regular
- Joined
- Jun 25, 2009
- Messages
- 140
Hello everyone, it has been a while, and I am afraid my mind is blank. I need ideas on the best way to set up an Excel worksheet that tracks expiration dates on products that we receive. I have a worksheet that I throw in the content of all POs and the receiving information, along with the current inventory. The issue is that on that sheet, items can and should be duplicated as we reorder them. Also, everyday I lookup the current inventory and thus, it is not a steady number. So my worksheet looks something like:
item#, Description, Qty received, Expiration date, Inventory upon arrival, current inventory
I was thinking, if I can have one sheet with just everything thrown in and then each item have its own ledger, problem with that is that we have over 2000 items and even doing a pivot, I would have to do 1 sheet for each item. Too long.
Any ideas?
item#, Description, Qty received, Expiration date, Inventory upon arrival, current inventory
I was thinking, if I can have one sheet with just everything thrown in and then each item have its own ledger, problem with that is that we have over 2000 items and even doing a pivot, I would have to do 1 sheet for each item. Too long.
Any ideas?