worksheet name in formula

[Guest]

Hi All

i have formula
=INDEX('C:\My documents\[Products.xls]September'!$A$1:$M$1000;
MATCH($A9;'C:\My documents\[Products.xls]September'!$A$1:$A$1000;
MATCH(C$20;'C:\My documents\[Products.xls]September'!$1:$1)
I have in workbook 12 sheets( 12 months)
I like to use cell A1 name of the month. Is it possible, that formula will
read sheet name from cell A1

 

[Guest]

Look here to see how to get the sheet name:

http://www.ozgrid.com/VBA/return-sheet-name.htm

 

[Guest]

Look here to see how to get the sheet name:

http://www.ozgrid.com/VBA/return-sheet-name.htm

 

[Peo Sjoblom]

You need an add-in, there is a built in function called INDIRECT that can do
this but only if the workbook is open, your use of the path indicates you
are pulling values from a closed workbook. You can download morefunc from
here

http://xcell05.free.fr/english/

it has a function called INDIRECT.EXT

ftp://members.aol.com/hrlngrv/

pull.zip will also work



--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

 

[Peo Sjoblom]

You need an add-in, there is a built in function called INDIRECT that can do
this but only if the workbook is open, your use of the path indicates you
are pulling values from a closed workbook. You can download morefunc from
here

http://xcell05.free.fr/english/

it has a function called INDIRECT.EXT

ftp://members.aol.com/hrlngrv/

pull.zip will also work



--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)