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

[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

 

[Don Guillett]

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.

 

[Arvi Laanemets]

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

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)

=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

 

[Arvi Laanemets]

Hi

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