How do I lookup the sheetname in a workbook

  • Thread starter Thread starter shriil
  • Start date Start date
S

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
 
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
 
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?
Click to expand...
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.
Click to expand...
I would like to pick up the date part of the Sheetname and use it in
another sheet as a text value.
Click to expand...
Is there any such worksheet function for doing the same?

shriil- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Thanks. this fulfills my requirement

shriil
 
Back
Top