Andrew,

Select cell C169, and run this macro:

Sub MakeLinksForAndrew()
Dim myCell As Range

For Each myCell In Selection
myCell.Formula = _
"='W:\Projects\" & Cells(myCell.Row, 1).Value & " " & _
Cells(myCell.Row, 2).Value & "\Financial Information\Monthly
Summaries\[" & _
Cells(myCell.Row, 1) & "&" Monthly Summary.xls]Sheet1'!$F$12)"
Next myCell
End Sub

are created.

HTH,
Bernie
MS Excel MVP

"Andrew" wrote in message
...
I need help writing a formula that will link a workbook file with thousands
of other workbooks files by using a formula using a standard file name
convention.

Here is the standard file naming convention:

'W:\Projects\ &A169 &" " &B169 & "\Financial Information\Monthly
Summaries\[" &A169 &" Monthly Summary.xls]Sheet1'!$F$12)

By using this formula I would like to use the auto fill feature to update
the folder/file references.

I have literally thousands of excel files that i need this master workbook
to link to. Entering in the values manually will take far to long to do.

Please help