Hello all,
I am trying to build a simple inventory form for the company I work for. What we need is a spreadsheet that will keep a running total of inventory between 3 different locations. There will be several products to keep track of. The "location" tabs need to report the current number in inventory to the "inventory" tab. We are using drop-down lists on the "location" tabs to choose the products. What I need help with is getting the "inventory" tab to calculate the number based on the product selected in the drop-down.
I hope this makes sense. I have attached a sample of what I am trying to achieve.
Thanks in advance!
Bookmarks