creating a link to another sheet in same workbook

skylined1

Board Regular
Joined
Mar 13, 2012
Messages
64
Project is shared, cannot use vba.

I have in A2 - A12, The names of different sheets in the workbook. I would like to create a link so when a user clicks on the cell, it will take them to the specified sheet.

Lets say cell A2 contains the text '1208', when pressed I would like it to open up the sheet 'A1208'

I've done something like this in the past, but cannot for the life of me remember how it was done. Sorry if this is a simple question.

Thanks for the help!
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

TheCman81

Well-known Member
Joined
Feb 28, 2012
Messages
535
Use Hyperlinks

Right Click your Cell - Hyperlink - Place in this document and select your sheet

Also make sure you typr in your Cell Ref ir A2
 
Last edited:

T. Valko

Well-known Member
Joined
May 9, 2009
Messages
16,623
Project is shared, cannot use vba.

I have in A2 - A12, The names of different sheets in the workbook. I would like to create a link so when a user clicks on the cell, it will take them to the specified sheet.

Lets say cell A2 contains the text '1208', when pressed I would like it to open up the sheet 'A1208'

I've done something like this in the past, but cannot for the life of me remember how it was done. Sorry if this is a simple question.

Thanks for the help!
You can use hyperlinks.

If A2 contains the sheet name 1208 what is A1208? Is that a cell address? Or, is the ACTUAL sheet name A1208?
 

skylined1

Board Regular
Joined
Mar 13, 2012
Messages
64
You can use hyperlinks.

If A2 contains the sheet name 1208 what is A1208? Is that a cell address? Or, is the ACTUAL sheet name A1208?

1208 is the tail number. the 'A' is to designate that it is an aircraft. The actual sheet name is A1208.
 

T. Valko

Well-known Member
Joined
May 9, 2009
Messages
16,623
1208 is the tail number. the 'A' is to designate that it is an aircraft. The actual sheet name is A1208.
Here are a couple of hyperlink formulas you can try.

A2 = 1208

Enter this formula in B2:

=HYPERLINK("#A1208!A1",A2)

Or, you can put the hyperlink formula directly in cell A2:

=HYPERLINK("#A1208!A1","1208")

The hyperlink will take you to cell A1 on sheet A1208.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,491
Messages
5,596,477
Members
414,070
Latest member
DuncanLucas

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