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 our items. This is the current set up of our doc, with a master list that I do not currently have access to, but a coworker does, that manages all of the Data Validation for columns C-H. Each drop down has a variety of values we use regularly to manage our intake and so we can find each item if/when our Access Database crashes multiple times a day.
Effectively, I’m looking for some way to track the quantities of the bags in column D in a separate sheet, as well as the potential for 1-2 more columns for hoods and/or batteries. This will free us up a substantial amount of time instead of having to count bags each week.
I’ve tried a few other solutions I’ve found on here with minimal luck. If I have to rebuild the entire thing from scratch to make something work, I definitely am up to doing that if it’s not possible with the current setup we run.
Thank you in advance for any help!
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 our items. This is the current set up of our doc, with a master list that I do not currently have access to, but a coworker does, that manages all of the Data Validation for columns C-H. Each drop down has a variety of values we use regularly to manage our intake and so we can find each item if/when our Access Database crashes multiple times a day. Effectively, I’m looking for some way to track the quantities of the bags in column D in a separate sheet, as well as the potential for 1-2 more columns for hoods and/or batteries. This will free us up a substantial amount of time instead of having to count bags each week.I’ve tried a few other solutions I’ve found on here with minimal luck. If I have to rebuild the entire thing from scratch to make something work, I definitely am up to doing that if it’s not possible with the current setup we run. Thank you in advance for any help! Read More
