Add formulas to specific columns

[alialeola]

Hi guys,

Could you help me insert the below formulas into my VBA code?
These are all empty columns, with the header on row 2, so formulas should be added to row 3.

 

[Michael M]

I would advise against the entire column.
But the last used row...I'm not near the computer atm.
So if no one helps out in the meantime, I'll repost tomorrow

 

[Peter_SSs]

Thanks for the code. It is quite unclear just what you have on your sheet, where it is and what you are trying to achieve so what I am about to suggest may well not be quite what you want but hopefully might nudge you in the right direction.
But please test with a copy of your workbook.

Try adding these blue lines right near the end of the code where shown.

    End With
    .Cells(3, LstCol - 6).Resize(LstRw - 2).Formula = "=1-H3/K3"
    .Cells(3, LstCol - 4).Resize(LstRw - 2).Formula = "=H3*1.2"
    .Cells(3, LstCol - 3).Resize(LstRw - 2).Formula = "=ROUND(K3*2,1)"
    .Cells(3, LstCol - 1).Resize(LstRw - 2).Formula = "=L3*M3"
End With
End Sub

 

[alialeola]

I would advise against the entire column.
But the last used row...I'm not near the computer atm.
So if no one helps out in the meantime, I'll repost tomorrow

Yes, thanks. By entire column, I actually meant the rows where there is data.

 

[kvsrinivasamurthy]

Reference Post #8
For the formulas given in post#1 which is the Last column.