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