Chris wrote:
I'm trying to link a sheet from one workbook to a sheet in another workbook,
and to update the info when it's changed on a daily basis...can anyone
help....have not been able to find out how to do this with the research I've
done...Thanks


Simplest way:
- Have both workbooks open
- in the cell to contain the link, type =
- Window to the other workbook and select the source cell
- hit Enter

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup