new cell for each day

  • Thread starter Thread starter Libby
  • Start date Start date
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))
 
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
(e-mail address removed)
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...
 
=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...
 
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...
 
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...
 
Back
Top