new cell for each day

L

Libby

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))
 
D

Don Guillett

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

Libby

The workbook is open
--
Libby


Don Guillett said:
Pls stay in your ORIGINAL thread. INDIRECT only works with OPEN workbooks.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
[email protected]
Libby said:
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))
Click to expand...
Click to expand...
 
D

Dave Peterson

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

or maybe...

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

(I'm not sure what's in A44.)

You don't need the +, either.

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))
Click to expand...
 
L

Libby

Cell a44 is the "yester"day of the month. the formula is not returning
anything its just showing the formula in the cell

by


Dave Peterson said:
=indirect("'[Apr MIR.XLS]Mid-City'!g"&$a$44+9))

or maybe...

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

(I'm not sure what's in A44.)

You don't need the +, either.

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))
Click to expand...
Click to expand...
 
D

Dave Peterson

Format the cell as General (anything but text).

Then reenter the formula.
Cell a44 is the "yester"day of the month. the formula is not returning
anything its just showing the formula in the cell

by

Dave Peterson said:
=indirect("'[Apr MIR.XLS]Mid-City'!g"&$a$44+9))

or maybe...

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

(I'm not sure what's in A44.)

You don't need the +, either.

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))
Click to expand...
Click to expand...
Click to expand...
 
Top