Code for calculation in cell where figures are entered

[ipbr21054]

Hi,
I need some advice please as not being able to get my head around this simple issue.

Column G = Column A + Column H

So i the user would enter a value in the cell at Column A & also enter a value in the cell at Column H, the combined total then would be shown in the cell at Column G
In i previous post for another issue but similair to this when a value is entered in the cell the Formaula etc is removed.

This is the part im stuck with.

Many thanks

 

[ipbr21054]

The user would enter a value in cell A1 and also cell G1
The two values when added together would be then shown in cell H1

The user would then continue with row 2 so A2 & G2 added & shown in H2

This continues down the page to row 30

 

[mikerickson]

Then just type the formula =A1+G1 in H1 and drag that downward.
I thought you were looking for something exotic.

 

[ipbr21054]

Many thanks,theres no suprise to say when i was doing it that it didnt stay in the cell.
Copying your code & putting into the cell / dragging down worked.

Have a nice day