Duplicate a change in formula to other rows

[Dredug]

In row 8, the formula is =A8+DL8+L8
In row 10, the formula is =A10+D10+L10
In row 14, the formula is =A14+D14+L14
In row 19, the formula is =A19+D19+L19


If I change the formula in Row 8 to =A8+DL8+L8+N8 how can I automatically update the formula in rows 10, 14 and 19 to add row N.

Thank you.

 

[Joe4]

Welcome to the Board!

Copy the formula that you just updated in row 8 to those other 3 rows.

If you are looking for some sort of automated solution, you would probably need to use VBA.

 

[Dredug]

Welcome to the Board!

Copy the formula that you just updated in row 8 to those other 3 rows.

If you are looking for some sort of automated solution, you would probably need to use VBA.

Thanks, Joe, I was looking for an automated solution as multiple rows require updating daily. I"m not familiar with VBA. Kind regards,

 

[kvsrinivasamurthy]

Formulas are not in all rows . Only selected rows as given in example. Is it so. The row numbers are always same.

 

[Joe4]

You did not mention what column this formula is in.
Let's say that it is in column S.

Then all you would have to do it update the formula in row 8 (cell S8) and run this little macro:

Sub MyCopyRows()

'   Copy formula from cell S8 to S10, S14, and S19
    Range("S8").Copy Range("S10")
    Range("S8").Copy Range("S14")
    Range("S8").Copy Range("S19")
   
End Sub

You can obviously adjust/expand it out as needed.

 

[Dredug]

You did not mention what column this formula is in.
Let's say that it is in column S.

Then all you would have to do it update the formula in row 8 (cell S8) and run this little macro:

Sub MyCopyRows()

'   Copy formula from cell S8 to S10, S14, and S19
    Range("S8").Copy Range("S10")
    Range("S8").Copy Range("S14")
    Range("S8").Copy Range("S19")
  
End Sub

You can obviously adjust/expand it out as needed.

That worked a treat Joe, thanks so much. What a wonderful resource this is. Kind regards,

 

[Joe4]

You are welcome!
Glad we were able to help!