Wildcards in other workbook cell refrence?

P

Pootler

Hello,

I am trying to reference a cell in a another workbook, for example

E:\CoreData\[C_SWAreaPerformanceData.may05.xls]PReports'!$F$31

This works fine, but I need to use something like a wild card as th
months change and I need the cell to read the current month. This i
what I have tried:

E:\CoreData\[C_SWAreaPerformanceData.*.xls]PReports'!$F$31

Excel does not like this, so is there another way of referencing th
cell?

Thanks
 
G

Gary Brown

Assume...

E:\CoreData\[C_SWAreaPerformanceData.
is in Cell A1

may05
is in Cell A2

..xls]PReports'!$F$31
is in cell A3

Formula in A4 =
=INDIRECT("'"&A1&A2&"'!"&A3)

Change cell A3 each month.

HTH,
 
Top