Use text from one cell in a formula in another. [EXCEL 2010]

Jeester

New Member
Joined
Sep 6, 2014
Messages
17
Dear All,

This is my first post so apologies if I have made any etiquette errors.

I am trying to hyperlink to different worksheets within my workbook when they are created, to do this I am using:

=HYPERLINK("#'Baker, Phil'!A1","More Info")

What I would like to do is to change "'Baker, Phil'" to a cell reference in the same sheet that would already have "Baker, Phil" typed in to it.

Perhaps something along the lines of this: (even though I know it doesn't work).

=HYPERLINK("#'"=A3"'!A1","More Info")

Or something along those lines.

EDIT: I want to do this so I can simple click and drag to as I want to lock the cells so that the people I am giving the workbook to cannot alter the formula (and so that they don't have to) every time a name changes.

Thank you very much

Jeester
 
Last edited:

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Forum statistics

Threads
1,213,549
Messages
6,114,264
Members
448,558
Latest member
aivin

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