I found the info. on the website very helpful. However, there is one problem
i cant seem to fix. Each time i enter the new figure it is added to the
existing figure i want, however if i should shift between worksheets or
change data in another cell which has no connection to the two columns im
using, the new figure keeps adding itself again and again. Example if i
overwrite 30 and my new figure is 70 if i edit other cells, the new figure
changes to 100, and if i do other changes it will change to 130 ans so on.
How do i correct this?

"Peo Sjoblom" wrote:

http://www.mcgimpsey.com/excel/accumulator.html

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Paula_p" wrote in message
...
Hi everyone,
I'm trying to create an inventory sheet where i have a correct record of
goods available for sale.

What i want is to be able to overwrite figures in a particular column and
have that added to figures in another column. For example. Say i have 25
Cds
and i sold 10, i now have 15 availible for sale. However, if i bought 50
more, i should now have 65. Is there a way i can write the figure bought
in a
cell and have that added to the figure in the existing stock?

Also, each time stock for a particular product is bought it is recorded in
the same cell, ie. the old figure is overwritten, so the 25 is replaced
with
50.
Thanks.