Copy Formulas Automatically

[tony_d]

Is it possible to copy a formula from cell C2 and paste it in C3 if a number is put in cell A2
This then needs to do the same if a value is put in A3 again copy & paste the formula one cell down.

I know I can just do it manually by dragging the formulas down but this way it neatens things up.


Thanks in advance.

 

[villy]

Do something like this

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    For i = 2 To Range("A" & Rows.Count).End(xlUp).Row
        Set A_Rng = Range("A" & i)
        Set C_Rng = Range("C" & i)
 
        C_Rng.Value = A_Rng * 2
    Next
End Sub

Modify the ranges and formulas to suits your need.