Updating excel 2003 cells.

Microsoft Book: office excel 2003 inside...
July 31, 2009 at 02:33:37
Specs: Windows XP, pentium 4 3.00Ghz. 1gb ram
Hi! Excel Gurus,

let say A1=2 and B1=5
then i add B1 with A1 in B1 which is = 7 i.e. B=7 (i entered this formula in B1 cell: =sum(5+A1)

Now the question is: How i can keep updating the B1 cell figure (7)?
for example

if A1=2 and B1=7 then,
when A1 is repleced with:
3 then B1=10 (i.e. 7+3)
6 then B1=16 (i.e. 10+6)
5 then B1=21
0 then B1=21
4 then B1 =25
please note that B1 should keep updating the figure of A1. And A1 figure could be any number.Also undo is must for B1 cell. Your solution will be very much appreciated.

See More: Updating excel 2003 cells.

Report •

July 31, 2009 at 06:31:12
What you are asking for is a perfect example of a Circular Reference, which is not allowed in Excel.

To state your question another way, what you essentially asking is "Can I use =SUM(B1+A1) in B1."

Try that and Excel will pop up the Circular Reference error message since it can't resolve a formula based on the value in the same cell as the formula.

Perhaps if you explained your ultimate goal, and why you want do what you're asking, we could come up with a better solution.

It may involve VBA, but I don't want to go down that path without some more details.

Report •

August 1, 2009 at 22:09:44
Thanks DerbyDad03 for your answer. one of my friend has already emailed me the macro for it which works perfectly as i need.

Report •

August 2, 2009 at 13:16:38
How did the macro handle your requirement that "undo is must for B1 cell"?

Undo's are typically an issue with macros.

Report •

Related Solutions

August 2, 2009 at 22:12:52
Derby, yes my friend told me that. you knows i have to use ' -' . say, if i entered 25 in A1 by mistake, i have to type -25 to undo it. Have a good day.

Report •

Ask Question