new cell for each day

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

 

[Don Guillett]

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

 

[Libby]

The workbook is open
--
Libby

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

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

 

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

 

[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

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

 

[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

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