Forum Discussion
Looking for a solution to automate inventory management of product accessories.
Hello Excel Community! I'm looking for some sort of formula to be able to create an additional sheet within my current Excel Book to best track the inventory of the accessories we need to sell ou...
I'm looking to create an additional sheet in this Book that will have our inventory of all of the Bag Types from Column D. This new sheet would have Column A through D as SKU, Description, Starting Quantity, and End quantity. I want to be able to connect it to the sheet in my original message so that when I choose one of those bag types, it automatically updates the inventory in the new sheet to reflect how many of each bag type remains.
I hope this makes sense, please let me know if you need additional info or clarification!
Thanks for the reply. Attached is a preliminary worksheet. If you have anything like this that you've started it would be helpful. I have a few questions. Does the amount of bags on your list indicate beginning inventory? How will outgoing inventory be indicated. Where does the SKU come from.
Thanks,
Regina
