cell data for external reference
 

Hey all, I have something that I just can't seem to figure out. cells h2 to
k33 are linking to a file such as "
[\\network_path\directory\xls_file]worksheet!h2" etc etc. my problem is
that the excel file is named with the month. What I have been trying to do
is create an external link that uses the value of a cell for the file data.
an example would be having my path in cell a1 and the current month in cell
b1 followed by the worksheet in cell c1. then in my group h2 to k33 instead
of the direct link it would be looking at the combination of the 3 cells in
row 1 that make up the link. Now as each month changes so does the reference
and only that month is displayed. Is this possible, it has to be right?

Thanks in advance for any help.
Frank

cell data for external reference
 

Hi Frank,

You could do use an INDIRECT function to generate the reference using the
'month' value in another cell, but the downside is that none of the
references will work unless the source workbook is open.

Cheers

--
macropod
[MVP - Microsoft Word]


"Frank" wrote in message
...
Hey all, I have something that I just can't seem to figure out. cells h2
to
k33 are linking to a file such as "
[\\network_path\directory\xls_file]worksheet!h2" etc etc. my problem is
that the excel file is named with the month. What I have been trying to
do
is create an external link that uses the value of a cell for the file
data.
an example would be having my path in cell a1 and the current month in
cell
b1 followed by the worksheet in cell c1. then in my group h2 to k33
instead
of the direct link it would be looking at the combination of the 3 cells
in
row 1 that make up the link. Now as each month changes so does the
reference
and only that month is displayed. Is this possible, it has to be right?

Thanks in advance for any help.
Frank