How do I lookup the sheetname in a workbook

[shriil]

How can I pick up the Sheet name of a particular sheet in a workbook?

I have a workbook with sheets named as expense110309, expense140309,
expense200309. For e.g. Sheet 'expense110309' contains relevant
information on expenses incurred on 11/03/09 (dd/mm/yy format).
Similarly 'expense140309' contains that of 14/03/09.

I would like to pick up the date part of the Sheetname and use it in
another sheet as a text value.

Is there any such worksheet function for doing the same?

thks

shriil

 

[Jarek Kujawa]

try:

in A2
=CELL("filename",A1)

=MID(A2,FIND("]",A2,1)+1,LEN(A2)-FIND("]",A2,1))

to get 140309

then pls provide more info if it's not enough

 

[slah]

try:

in A2
=CELL("filename",A1)

=MID(A2,FIND("]",A2,1)+1,LEN(A2)-FIND("]",A2,1))

to get 140309

then pls provide more info if it's not enough

How can I pick up the Sheet name of a particular sheet in a workbook?

I have a workbook with sheets named as expense110309, expense140309,
expense200309. For e.g. Sheet 'expense110309' contains relevant
information on expenses incurred on 11/03/09 (dd/mm/yy format).
Similarly 'expense140309' contains that of 14/03/09.

I would like to pick up the date part of the Sheetname and use it in
another sheet as a text value.

Is there any such worksheet function for doing the same?

shriil- Hide quoted text -

- Show quoted text -

Thanks. this fulfills my requirement

shriil