referencing a cell in a workbook on the web.
 

Is there a way to have a cell in a workbook on my hard drive reference a cell
in a workbook on the web. The web address is static.

Thanks in advance!

JD

referencing a cell in a workbook on the web.
 

Yes, the link would look something like this...

='http://website/folder/[filename.xls]sheetname'!$A

--
paulharve
-----------------------------------------------------------------------
paulharvey's Profile: http://www.excelforum.com/member.php...fo&userid=2522
View this thread: http://www.excelforum.com/showthread.php?threadid=39189