Require VBA Code for copy the calculation result to one column synchronously

Step 1
After both A2 and B2 are entered, the calculation result of cell C2 = A2*B2 , Copy C2 result to E2
Example
A2 cell key in 5 , B2 cell key in 6
So C2 cell get the result 30
PS : A2 and B2 must be completely entered before C2 can be calculated
At this time, copy the result of C2 cell to E2 cell

Step 2
Example
A2 cell key in 2 , B2 cell key in 9
So C2 cell get the result 18
PS : A2 and B2 must be completely entered before C2 can be calculated
At this time, copy the result of C2 cell to E3 cell

To copy the cell content you would need VBA. My suggestion is to use event handler for Change event in Sheet2:

Please Login or Register  to view this content.

But to have it working properlu in case you enter a whole new pair of values, you would need to clear the A2:B2 content before.
Otherwise you enter new A2 and oldB2*newA2 will be calculated (this result is not needed) and then when you enter also new B2 proper result newB2*newA2 is stored in first available cell in column E.



But probably it would be better to write these pairs to be multiplied in consequtive rows. Then the code would be:

Please Login or Register  to view this content.

See attached file (macros execution have to be enabled).

First of all, thank you first, the first code is what I thought, but there is still a small problem. A2 CELL wants to change the quantity, B2 CELL UNIT PRICE also wants to change the unit price, so that it can be recorded. May I ask the teacher where to change the code?

It means that both A2 and B2 must be changed at the same time to establish a record

The second method and the suggestion do not need to write code, E COLUMN becomes redundant, just use the original C COLUMN.

Thank you, teacher

I think it still doesn't work. I can't handle it with a trigger event, because I changed one and recorded it, and the other has not been changed yet.
Change to a button to confirm the event

Originally Posted by jindon

Do you mean only when B2 changed?

Please Login or Register  to view this content.

Awesome, that does the trick! Much appreciated! Thank you, Jindon teacher

At the same time, thank you Mr. KAPER teacher for your kind help