addinf formula via VBA

[JeremyGraham95]

i am working on an inventory spreadsheet and am trying to finish out the last couple tasks.I am trying to enter a formula "A3-B3 from sheet 1" and paste it in sheet 2. and i want to do the whole column which goes down to A128.

 

[skywriter]

This assumes you want to start in A1 on sheet 2 since you didn't specify.

It also assumes there's a space between the word sheet and the number as you show in your example.

If anything is different you will have to adjust the code or you will get an error.

Sub Test()
    With Worksheets("Sheet 2")
        .Range("A1:A128").Formula = "='Sheet 1'!A3-'Sheet 1'!B3"
    End With
End Sub

 

[JeremyGraham95]

I would be starting in the first empty column on the worksheet "sheet 2". but i actually need the code to find the last 2 columns and use that formula for those 2 columns.