Soldato
- Joined
- 6 Jun 2011
- Posts
- 2,741
Hey guys,
So as the title says, I have Excel 2010 and basically have different items which I am trying to keep track of stock.
The best way I could think of was to have the initial total amounts for each item in seperate cells and then search down the column of sold items to find matching item names and -1 off of the corresponding item total. Not really sure how to do this though, or even if this is the best way.
Any help appreciated,
Cheers
So as the title says, I have Excel 2010 and basically have different items which I am trying to keep track of stock.
The best way I could think of was to have the initial total amounts for each item in seperate cells and then search down the column of sold items to find matching item names and -1 off of the corresponding item total. Not really sure how to do this though, or even if this is the best way.
Any help appreciated,
Cheers
