I have a problem witha spreadsheet in excel 2010 I have 3 columnsin sheet 1 and 1 column in sheet 2 the columnsare named in sheet 1 stock level , addition , total stock in sheet 2 the column is named picked, I want the figure in total stock columnto be the result of a formula eg = stock level + addition - picked and leaving the calculation in total stock column and this figure will only change when I add stock it always depletes from the picking figure can someone help
Thank you