Hi Laura,

It can be done but only with a Change event macro! Do you really want this
instead of a simpler method: entering your numbers in A2, A3, etc. and click
on Autosum in the next cell when you finished?

Regards,
Stefi

€žLaura ( '_' )€� ezt Ã*rta:


Excel 2000

Hiya, I have a question for all you brainboxes out there!
Im VERY new to excel so please explain clearly or I'll be completley lost!!

In the cell A3 I would like to have a "Grand Total".
In the cell A2, I would like to enter a number, eg. 400 (this would then
appear in A3 as 400), THEN I would like to enter another number, eg. 307 in
cell A2. (this wouuld then appear in A3 as 707).

I hope that explains it, I find it a bit confusing.
Thanks for any help you can offer :)
--
@---}--
Laura..... :)
Liverpool, England