i am setting up a stock record spreadsheet on excel. I want to be able to
enter incoming quantities of stock into the same cell on the spreadsheet each
time and have them tally onto the in stock total each time, but without
forgetting what the last value added on was. I know the basics of how to
calculate addition and subtraction formulas, but dont know how to get a
single cell data entry. At present every time i enter a figure, it goes into
the next cell down in the column, and the total cell adds up every cell in
the column to reach a total.