adding/subtracting a value to cell permanently

M

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.
 
A

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
 
Top