Looking for formula to keep inventory....Maybe vlookup

**Vicky Blanks** · 08-15-2013, 11:07 AM

I have a master inventory sheet with 2 tabs. First tab is the master inventory....first column: Item #, 2nd: current inventory. At the end of each day a report is pulled into the same book on a different tab(titled 'daily sales'), first colum: Item #, 2nd column: total sold for the day. I need a formula (maybe vlookup, but not sure) to look up the item # on the daily sales tab, and subtract the total sold for the day, from the master inventory tab, ultimately only updating the items sold that day. I will copy, paste special values, so that I can start over using the same formula every day.

**judgeh59** · 08-15-2013, 11:18 AM

howdy and welcome to the forum....can you upload a small sample with company confidential data removed?....it makes things easier to help out....thanks

**Vicky Blanks** · 08-15-2013, 11:32 AM

item list.xlsx
This is just something I'm trying to figure out so obviously the current inventory #'s are not accurate. However, the 8.15 sale tab is an accurate report puuled from quickbooks as it will be done every day.

**judgeh59** · 08-15-2013, 11:54 AM

Thanks - that works.....so, I changed a few thing and see if it will work for you....I created a daily sales and balance column....you can copy special paste your balance into OHI - on hand inventory, then you can copy and paste your new daily sales on top of the old daily sales....this is a bit a tweaky way to do this but it should work....

**judgeh59** · 08-15-2013, 05:14 PM

I'm glad it worked for you.....as per forum rules....if you get a chance please set this thread to "Solved"....check the forum on how to do that....and thanks for the star....