Hi All,

I am trying to create a hyperlink to another workbook and what I have is a column with sequentially numbered cell names which are the same as the other workbooks im trying to link to. I have a few thousand of them so what I would like is, rather than putting in the file name at the end of the location (eg :c\files\file1) I would like to have the current cell info in the location link (eg :c\files\"A1") and hopefully I can just drag that down the whole column and it will update the cell, like :c\files\"A1" then :c\files\"A2" etc. etc.

I have pasted something which is similar to what I want below (albeit minus the Cell link)

Link to Another Excel File
To create a link to another Excel file, in the same folder, just use the file name as the link_location argument for the HYPERLINK function.
=HYPERLINK("MyFileC.xlsx","FileC")
For files that are up a level or more in the hierarchy, use two periods and a backslash for each level. In this example, the file is 1 level up.
=HYPERLINK("..\MyFileB.xlsx","FileB")
In this example, the file is 2 levels up.

Ant help would be greatly appreciated
Cheers,
Ben