Want to make A1=(A1+B1)

I thought this would be simple, but it's creating a circular reference.

I have series of cells, and I want to create a macro so that when I hit a key, it will update a "Total" cell. Almost like a calculator. For instance, to make it simple...

Today
A1 = 4

All-Time Total
A2 = (Running total of all A1 contents)

What I want to do is, like the Equal button on a calculator, update A2 with a formula like "A2=A2+A1" and once it's been added, then change A1 to 0.
The only way I can think of doing this would be keep a log for every day, and just do something like A2=SUM(A1:Z1). This would be quite cumbersome for me.
I was thinking of of creating a macro and doing something like A3=A1+A2, and then copying the contents from A3 to A2, but that's giving me an error.

Any ideas? Thanks for reading.

Try this:

Please Login or Register  to view this content.

I _REALLY_ need to learn Visual BASIC. I know how to do what I want to do in BASIC, but that language is deader than Latin. Thanks!