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

You don't need a macro

="'"&L2&"'!Aug08"

--
__________________________________
HTH

Bob

"stuck4once" wrote in message
...
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

Hi Bob,

Thanks for your quick response.

The problem is, I need this to actually bring back the result of what is in
the named range on the other spreadsheet, where as this just shows the file
name and the range.

"Bob Phillips" wrote:

You don't need a macro

="'"&L2&"'!Aug08"

--
__________________________________
HTH

Bob

"stuck4once" wrote in message
...
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