Automatically change sum

Hi Chetan Vera and welcome to the Forum.

To make a similar formula in B7, first click in A7 (with your new formula), The cell will get a thick border (say green). If you see a small square in the bottom right of the cell, that's the "fill handle" *. Click and hold that then drag it into B7 until the thick border surrounds A7:B7. Release the mouse and you'll find the formula in B7 is like A7 but referring to cells in B7. release.

You can also fil down in a similar way.

* If that small square fill handle isn't present:

1. Click File > Options
2. Click Advanced.
3. Under Editing Options, check the Enable fill handle and cell drag-and-drop box.

Hope this helps. If so, please remember to mark this Answer as Selected.

Hello Chetan Vora,

John has provided a solution but you haven't responded to let him know if that is the method you want.

If you want use VBA you could use a Worksheet_Change event. To do so add the following to the worksheet code window:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target = Range("A7") Then
    Range("A7").Copy Range("B7")
End If

End Sub

This code references the cells you state in your explanation. This code will only be triggered (run) when cell "A7" changes. When the formla in "A7" is changed it will be copied to cell "B7".

Please let John and I know which method you prefer; and mark that answer as selected.

Cheers   :-)