adding/subtracting a value to cell permanently

[marcky202]

hey guys.. i need your help.. How do i add/subtract a value from a cel
permanently? I need to know how to do that because I am doing a schoo
project.. it's about a grocery store..

for example.. if Sheet2!D2 contains the stocks in the grocery.. and yo
enter in Sheet1!B2 the quantity desired by the user to be bought.. afte
the transaction, how would i subtract permanently the quantity bought b
the user from the stocks left in the grocery? coz everytym i change th
quantity, the stocks also changes.. i want to make changes permanen
everytym i change the quantity desired.. how do i do that?

e.g.
Sheet2!D2 = 100
Sheet1!B2 = 40

then

Sheet1!D2 = 60 <-- should stay that way.

 

[BenjieLop]

See if this will be of help to you ...

Enter in Sheet1D2: =Sheet2!D2-B2

 

[AlfD]

Hi!

I think you might be looking for an accumulator cell.

Have a look at this site:
http://www.mcgimpsey.com/excel/accumulator.html

Should get you going.

Al

 

[Alex Delamain]

Benjielop - That won't do it because it leaves the original stock o
sheet2 at its opening level of 100.

I am assuming that each transaction will be entered on sheet1 and th
OP wants this amount deducted from the starting stock. He needs th
stock level to reduce with each transaction. Logically then "ne
D2"=initial D2 - transaction.

As this is a circular reference it may need a macro or VB (about whic
I know less than very little). Any experts out there