auto create hyperlink map the same cell name with worksheet name

**only_lonely** · 07-15-2012, 11:47 AM

i have a excel sheet which contains manay worksheet
at content worksheet, i created a cell (one clolumn) and the name is same as with all other worksheet

worksheet 'content'
cell A 'worksheet ID'
1
2
3
4

other worksheet
worksheet '1'
worksheet '2'
.
.
.

how do i make the content page auto insert hyperlink?
so when I click cell A1 it will goes to worksheet 1, and so on.

**martindwilson** · 07-15-2012, 12:24 PM

use =hyperlink() see attached for 3 ways
you can also use insert /hyperlink to place in this document option

**only_lonely** · 07-18-2012, 02:23 AM

thanks for the solution.
i was thinking if the link can be auto generated
for example at the content page, i already have the text "1" and worksheet "1" is created later.
then i can update all existing text at content page in one go. now i need to insert the formula one by one.

**martindwilson** · 07-18-2012, 04:07 AM

careful you don't wear yourself out with all that typing,you only do it once then drag down as each sheet is created

**only_lonely** · 07-19-2012, 06:16 AM

i can't see the formula filled in series when i drag to copy.
how Do I copy?

**only_lonely** · 07-19-2012, 08:32 PM

i can't see the formula filled in series when i drag to copy.
how Do I copy?

**martindwilson** · 07-20-2012, 05:05 AM

use the 3rd option
=HYPERLINK("#"&H2&"!A1",H2) and drag to fill

right click cell then drag fill down
if the menu gets in the way so you cant see the fill handle right click again but on the cell border, the menu clears and you can then use the fill handle to drag down