Use Cell Content to Build Link
 

Hi -

I am trying to link one cell to another cell in another document on the
network. The actually linking of the cells is easy
"=http://server/folder/[filename.xls]Sheet1'!$A$1" but the part I can't
get is ...

I want to use another cell's content as part of the url. For example,
if cell A1 contained the folder that the file was in then, then I would
want to use that value so that I could change the folder in all of the
links at one time. For example, if A1=temp, then the link would be
"=http://server/temp/[filename.xls]Sheet1'!$A$1". I've tried
"=CONCATENATE("=http://server/",A1,"/[filename.xls]Sheet1;!$A$1)" ...
it puts together the string correctly, but then the target cell
displays the link, not the contents of the remote cell.

I think if there's an actual function that retrieves the cells contents
(instead of just an equals sign) I would be set, but I can't figure that
out. Thanks for the help.


--
flattire00101
------------------------------------------------------------------------
flattire00101's Profile: http://www.excelforum.com/member.php...o&userid=24409
View this thread: http://www.excelforum.com/showthread...hreadid=380091

try the indirect function
=indirect("=http://server/"&A1&"/[filename.xls]Sheet1;!$A$1)")

"flattire00101" wrote:


Hi -

I am trying to link one cell to another cell in another document on the
network. The actually linking of the cells is easy
"=http://server/folder/[filename.xls]Sheet1'!$A$1" but the part I can't
get is ...

I want to use another cell's content as part of the url. For example,
if cell A1 contained the folder that the file was in then, then I would
want to use that value so that I could change the folder in all of the
links at one time. For example, if A1=temp, then the link would be
"=http://server/temp/[filename.xls]Sheet1'!$A$1". I've tried
"=CONCATENATE("=http://server/",A1,"/[filename.xls]Sheet1;!$A$1)" ...
it puts together the string correctly, but then the target cell
displays the link, not the contents of the remote cell.

I think if there's an actual function that retrieves the cells contents
(instead of just an equals sign) I would be set, but I can't figure that
out. Thanks for the help.


--
flattire00101
------------------------------------------------------------------------
flattire00101's Profile: http://www.excelforum.com/member.php...o&userid=24409
View this thread: http://www.excelforum.com/showthread...hreadid=380091