Display Sheet Reference in Cell

awasson

New Member
Joined
Jun 24, 2011
Messages
3
I have a cell that is hyperlinked to a worksheet in the same workbook. I want to also display the the tab name in a cell. The tab name changes every week and I don't want to have to change it on both the tab and the cell that references it. I want to change the tab and then it will automatically update the cell that references it.

I'm using Excel 2007.

Thanks for any help.
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Put this formula in a cell of your choice:

=REPLACE(CELL("filename",A1),1,FIND("]",CELL("filename",A1)),"")

Change the A1 to whatever cell you put this formula in.
 
Upvote 0
Wow...you are good...and fast! Thanks, this worked great except that my cell that displays the reference is sheet 1 and I need to reference another sheet. My sheet one is like the table of contents (menu) or summary and then each sheet has the detail.
 
Upvote 0
I was able to accomplish what I needed by using your formula pasted (out of site) into each sheet, then linked to each pasted formula from my menu sheet.
Thanks very much, this really helped me out.
 
Upvote 0

Forum statistics

Threads
1,224,609
Messages
6,179,875
Members
452,949
Latest member
Dupuhini

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
Back
Top