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
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

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
 

Forum statistics

Threads
1,144,364
Messages
5,723,939
Members
422,527
Latest member
TotalBeginner201

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top