Re: new cell for each day

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


Pls stay in your ORIGINAL thread. INDIRECT only works with OPEN workbooks.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"Libby" <Libby@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:76C85A46-5B85-4AEF-9BAE-7106AEF6AE39@xxxxxxxxxxxxxxxx
I am trying to use the date cell in one workbook to determine what cell of
another workbook that I pull. so if today is the 6 then it will pull cell
g12 in
another workbook.


=+'[Apr MIR.XLS]Mid-City'!INDIRECT("g"&$a$44+9))
--
Libby

.

Quantcast