Excel Cell Reference To Itself

Question

Hello there

I want to self reference a cell and clear its content after loose focus... Lets say i have  a worksheet with cell A1 and A2, 

if i enter a value lets say 50 in cell A1, i want it to be replicated in cell A2, then when the mouse leaves cell A1, cell A2 will still hold the value of 50 then the cell A1 will clear to 0 but cell A2 will still retain the value replicated to it, then when i have another value that i enter in A1 lets say 30, the cell A2 will add to the value of 30 to become 80 then cell A1 will still clear to 0 for another input as in a loop.

any help will be appreciated.

thanks

Answer 1

Hi Emeka

I am Dave, an Independent Advisor, I will help you with this . . .

This cannot be done with an Excel formula, because a cell can only hold data or a formula, you would need to create a VBA Macro to do this, which would be triggered by a change in the value in cell A1 to increment the value in cell A2

Answer 2

okay. please can you help me with the VBA marco, it will be highly appreciated