=LOOKUP(A16,'I:\Materials Meeting\[AM WIP_1117.xls]

  • Thread starter Thread starter firebird96
  • Start date Start date
F

firebird96

=LOOKUP(A16,'I:\Materials Meeting\[AM WIP_1117.xls]Entr
Page'!$A$4:$A$41,'I:\Materials Meeting\[AM WIP_1117.xls]Entr
Page'!$N$4:$N$41)

___________________

I want to change the above formula by making the date (1117) variable.
I want to replace 1117 with something like:

month(now())& day(now())

Each day I want the formula to look the information up in a differen
file.

Am I on the right track or is there a better way to do this?

Thanks,
Kevi
 
You might try putting your formula in a cell and then using indirect in the
formula or create a defined name and just use the name in the formula.
 
Hi

With INDIRECT(), it'll work only when the other file is opened too.


--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets


Don Guillett said:
You might try putting your formula in a cell and then using indirect in the
formula or create a defined name and just use the name in the formula.

--
Don Guillett
SalesAid Software
(e-mail address removed)
firebird96 said:
=LOOKUP(A16,'I:\Materials Meeting\[AM WIP_1117.xls]Entry
Page'!$A$4:$A$41,'I:\Materials Meeting\[AM WIP_1117.xls]Entry
Page'!$N$4:$N$41)

___________________

I want to change the above formula by making the date (1117) variable.
I want to replace 1117 with something like:

month(now())& day(now())

Each day I want the formula to look the information up in a different
file.

Am I on the right track or is there a better way to do this?

Thanks,
Kevin
Click to expand...
Click to expand...
 
Hi

You have to write a procedure, or even better workbooks Open event, which
will rewrite formulas.
 
Back
Top