Adding up in Excel.

Hi.
First of all, thanks again for this fantastic Forum. I would like to know if this is possible to do.
Cell A1 is currently empty and without any formulas in it. I am going to enter data in B1. Lets say 100. As soon as I press enter this value must show in cell A1. Here is the trick. As soon as this value is entered in A1, I want B1 to go blank again. Now I enter 200 in B1 and after entering A1 must show 300, (100+200) and B1 must go blank again.

The reason for this is I have to update the worksheet every day with a lot of data and at the moment I had to add the data on the sheet to the data I want to update with using a calculator and then enter it back in A1. If there is a formula for this I can update A1 everytime by just putting the new value I want to add in B1 and press enter.

Thanks for your time.

Lukas.

Hello Lukas,

You can't do this with a formula, but you can do it with a macro. Specifically the Sheet Change event. i.e.

Please Login or Register  to view this content.

Regards

Please Login or Register  to view this content.

NOT

Please Login or Register  to view this content.

you put it in the woeksheet module not a new module ,you dont run it it is automatic

Thanks, it is working. I had it in a new module. One more thing. Since this is a macro and not a formula that you can copy and paste, is it a big change to make if I want to do the same with (B2-A2) and (B3-A3) and so on?

Thanks a lot.

For *any* cell in column B

Please Login or Register  to view this content.

Regards

I thought that this was working. Has something changed?

Where do you get that error? What line of code?

Post the sample workbook please.

Regards

This thread is 8 years old. Please start a new thread if you have a question.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread