adding automatically

N

noelf

hi everyone

please help

i'd like to be able to add automatically from the same cell.
for example
in a1 i have 1 apple there
i'd like to be able to type 1 again in a1 and it automatically adds i
to 2 in a1

can this be done?

thanks in advanc
 
P

Paul B

Have a look here http://www.mcgimpsey.com/excel/accumulator.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Top