I have the following formula to try and link to a cell in another workbook
but want to reference a new cell each day. I am getting a # ref. Can
somebody help with this please.

=INDIRECT("'"&$A$44&"'[mar MIR.xls]mid-city'!$g$39")
--
Libby