Wildcards in other workbook cell refrence?

**Pootler** · 06-02-2005, 10:27 AM

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 the months change and I need the cell to read the current month. This is what I have tried:

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

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

Thanks
P

Gary Brown · 06-02-2005, 01:05 PM

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,
--
Gary Brown
[email protected]
Please rate this posting if it is helpful to you.

"Pootler" wrote:

>
> 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 the
> months change and I need the cell to read the current month. This is
> what I have tried:
>
> E:\CoreData\[C_SWAreaPerformanceData.*.xls]PReports'!$F$31
>
> Excel does not like this, so is there another way of referencing the
> cell?
>
> Thanks
> P
>
>
> --
> Pootler
> ------------------------------------------------------------------------
> Pootler's Profile: http://www.excelforum.com/member.php...o&userid=23977
> View this thread: http://www.excelforum.com/showthread...hreadid=375970
>
>

Gary Brown · 09-05-2005, 10:05 PM

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,
--
Gary Brown
[email protected]
Please rate this posting if it is helpful to you.

"Pootler" wrote:

>
> 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 the
> months change and I need the cell to read the current month. This is
> what I have tried:
>
> E:\CoreData\[C_SWAreaPerformanceData.*.xls]PReports'!$F$31
>
> Excel does not like this, so is there another way of referencing the
> cell?
>
> Thanks
> P
>
>
> --
> Pootler
> ------------------------------------------------------------------------
> Pootler's Profile: http://www.excelforum.com/member.php...o&userid=23977
> View this thread: http://www.excelforum.com/showthread...hreadid=375970
>
>

Gary Brown · 09-05-2005, 11:05 PM

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,
--
Gary Brown
[email protected]
Please rate this posting if it is helpful to you.

"Pootler" wrote:

>
> 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 the
> months change and I need the cell to read the current month. This is
> what I have tried:
>
> E:\CoreData\[C_SWAreaPerformanceData.*.xls]PReports'!$F$31
>
> Excel does not like this, so is there another way of referencing the
> cell?
>
> Thanks
> P
>
>
> --
> Pootler
> ------------------------------------------------------------------------
> Pootler's Profile: http://www.excelforum.com/member.php...o&userid=23977
> View this thread: http://www.excelforum.com/showthread...hreadid=375970
>
>

Gary Brown · 09-06-2005, 12:05 AM

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,
--
Gary Brown
[email protected]
Please rate this posting if it is helpful to you.

"Pootler" wrote:

>
> 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 the
> months change and I need the cell to read the current month. This is
> what I have tried:
>
> E:\CoreData\[C_SWAreaPerformanceData.*.xls]PReports'!$F$31
>
> Excel does not like this, so is there another way of referencing the
> cell?
>
> Thanks
> P
>
>
> --
> Pootler
> ------------------------------------------------------------------------
> Pootler's Profile: http://www.excelforum.com/member.php...o&userid=23977
> View this thread: http://www.excelforum.com/showthread...hreadid=375970
>
>

Gary Brown · 09-06-2005, 01:05 AM

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,
--
Gary Brown
[email protected]
Please rate this posting if it is helpful to you.

"Pootler" wrote:

>
> 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 the
> months change and I need the cell to read the current month. This is
> what I have tried:
>
> E:\CoreData\[C_SWAreaPerformanceData.*.xls]PReports'!$F$31
>
> Excel does not like this, so is there another way of referencing the
> cell?
>
> Thanks
> P
>
>
> --
> Pootler
> ------------------------------------------------------------------------
> Pootler's Profile: http://www.excelforum.com/member.php...o&userid=23977
> View this thread: http://www.excelforum.com/showthread...hreadid=375970
>
>

Gary Brown · 09-06-2005, 02:05 AM

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,
--
Gary Brown
[email protected]
Please rate this posting if it is helpful to you.

"Pootler" wrote:

>
> 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 the
> months change and I need the cell to read the current month. This is
> what I have tried:
>
> E:\CoreData\[C_SWAreaPerformanceData.*.xls]PReports'!$F$31
>
> Excel does not like this, so is there another way of referencing the
> cell?
>
> Thanks
> P
>
>
> --
> Pootler
> ------------------------------------------------------------------------
> Pootler's Profile: http://www.excelforum.com/member.php...o&userid=23977
> View this thread: http://www.excelforum.com/showthread...hreadid=375970
>
>

Gary Brown · 09-06-2005, 03:05 AM

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,
--
Gary Brown
[email protected]
Please rate this posting if it is helpful to you.

"Pootler" wrote:

>
> 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 the
> months change and I need the cell to read the current month. This is
> what I have tried:
>
> E:\CoreData\[C_SWAreaPerformanceData.*.xls]PReports'!$F$31
>
> Excel does not like this, so is there another way of referencing the
> cell?
>
> Thanks
> P
>
>
> --
> Pootler
> ------------------------------------------------------------------------
> Pootler's Profile: http://www.excelforum.com/member.php...o&userid=23977
> View this thread: http://www.excelforum.com/showthread...hreadid=375970
>
>