OK, I did not realize you had no background at all in VBA.
Open the VBA editor by hitting ALT-F11. See this page for details.
Right click on the tree under your file and select Insert Module. You will get a new module called Module1. Double click on it. Put the following code into that module. You did not say what worksheet you want these formulas to go it. This example uses Sheet1 but you will need to change it if it's not right.
Public Sub InsertFormulas()
With Worksheets("Sheet1")
.Range("T17").Formula = "=[w" & Range("$S$17") & ".xlsm]Results!$T$101"
.Range("T18").Formula = "=[w" & Range("$S$17") & ".xlsm]Results!$T$100"
.Range("T19").Formula = "=[w" & Range("$S$17") & ".xlsm]Results!$T$98"
.Range("T20").Formula = "=[w" & Range("$S$17") & ".xlsm]Results!$T$99"
.Range("T22").Formula = "=[w" & Range("$S$17") & ".xlsm]Results!$F$21"
.Range("T23").Formula = "=[w" & Range("$S$17") & ".xlsm]Results!$G$23"
End With
End Sub
Now you can run InsertFormulas from the Macros list.
Bookmarks