is it possible to Reflect sheet name in Cell by formula

curiosity

New Member
Joined
Oct 11, 2006
Messages
9
Is there a way to reflect the sheet name in a cell by formula??


I have 50 sheets each named by customer id account number

is it possible to have a cell reflect the sheet name by a formula

eg cell a2 = sheet name ???

I dont want to have to manually type in the customers id number in cell a1 x 50 every time I do this work book..

Cheers,

Steve
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
Steve

Here's one way. Note that the file must already be saved for this to work.

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-SEARCH("]",CELL("filename",A1)))

Tony
 

curiosity

New Member
Joined
Oct 11, 2006
Messages
9
G'day lenze,

Nice thank you for the tip

The reason I wanted it in a cell is the sheet numbers are client numbers and I needed to fill the cells below a2 to a200 with client numbers and do the same on 50 other sheets.

So having it in a cell I could easily do it through the work book and then drag the cells and fill.

Steve
 

Watch MrExcel Video

Forum statistics

Threads
1,113,956
Messages
5,545,177
Members
410,668
Latest member
Gaexel
Top