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.

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>

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
>
>