I have a column in my master project list, column L that holds filenames of
all the project that are being worked on. E.g Column L row 2 =
\\Housing\project1.xls

It is possible to create a macro that will use this cell and the filename to
insert a formula in Colum M row 2 to reference to a named range on the sheet?

So Cell M2 ='\\Housing\project1.xls'!Aug08 once the macro has run?

Any help on this will be greatly appreciated.

Many thanks

regards

Arran