Hi Guys, thanks for looking. Im creating an inventory stock list for my
fresh produce company and have a list of products with a column of
'stock on hand'. I also have two other columns, one which takes away
sold Quantities of produce from the total stock on hand, and one that
adds to it. Now the problem is that as i sell the products i want to
take away from the stock on hand, i use a simple formula which
subtracts the sold from stock on hand. but i want it doing 'calculator
style' so that i can type a number, say i sold 7 of an item, i typed it
in the sold cell, press enter and it would be gone yet taken away from
the total stock on hand, but what happens is the quantity stays in the
sold cell, it does not clear off. can anybody help me, any help is
always appreciated. Cheers. :( :)


--
bobby911
------------------------------------------------------------------------
bobby911's Profile: http://www.excelforum.com/member.php...o&userid=24627
View this thread: http://www.excelforum.com/showthread...hreadid=382144