How to hyperlink across multiple tabs(worksheets)

[sivakr4056]

Hi,

I have one excel it has 2 tabs

first tab has all data in column A(all are unique rows).
ex:
column A
A
B
C
D

in second tab column c has few rows(these rows are just part of first tab data)
Ex:
Column C
C
D

my requirement is , if I select row D(hyperlink) in second tab, I want to go to first tab automatically and display only D row.

please suggest me how can I do this

thanks in advance for your help

 

[AngelEG]

Are you looking to go back to the first tab and filter everything but the value you clicked or only position in the value you clicked.

Please clarify so we can provide the appropriate assistance.

Cheers,

Angel

 

[sivakr4056]

Thanks Angel for your response

I am okay with either one, positioning at the selected one or filtered everything except selected in first tab.

But I want to do this dynamically on whole column C in second tab. Since I have lot of data in Column C in second tab.i provided above details only for example.

 

[AngelEG]

Hi Sivakr4056,

Sorry for the late reply, here's a possible solution to you scenario:

Say you have a worksheet called All with the following data:
All

[TABLE="class: grid, width: 100"]
<tbody>[TR="bgcolor: #cacaca"]
[TD][/TD]
[TD="align: center"]A[/TD]
[/TR]
[TR]
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: center"]A[/TD]
[/TR]
[TR]
[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: center"]D[/TD]
[/TR]
[TR]
[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: center"]E[/TD]
[/TR]
[TR]
[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: center"]F[/TD]
[/TR]
[TR]
[TD="bgcolor: #cacaca, align: center"]8[/TD]
[TD="align: center"]G[/TD]
[/TR]
[TR]
[TD="bgcolor: #cacaca, align: center"]9[/TD]
[TD="align: center"]H[/TD]
[/TR]
[TR]
[TD="bgcolor: #cacaca, align: center"]10[/TD]
[TD="align: center"]I[/TD]
[/TR]
</tbody>[/TABLE]

And the second sheet called Few would have the link on column B next to the letter you want to link to like this:

Few

[TABLE="class: grid, width: 500"]
<tbody>[TR="bgcolor: #cacaca"]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B
[/TD]
[/TR]
[TR]
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD]D[/TD]
[TD]#All!A5
[/TD]
[/TR]
[TR]
[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD]I
[/TD]
[TD]#All!A10
[/TD]
[/TR]
</tbody>[/TABLE]

Spreadsheet Formulas

Cell Formula B1 =HYPERLINK("#All!"&ADDRESS(MATCH(A1,All!$A:$A,0),1,4)) B2 =HYPERLINK("#All!"&ADDRESS(MATCH(A2,All!$A:$A,0),1,4)) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4


If you don't want to see the Link formula you can add a friendly name by modifying the formula to:
=HYPERLINK("#All!"&ADDRESS(MATCH(A1,All!$A:$A,0),1,4),"Link")

Hope it helps.

Angel

Thanks Angel for your response

I am okay with either one, positioning at the selected one or filtered everything except selected in first tab.

But I want to do this dynamically on whole column C in second tab. Since I have lot of data in Column C in second tab.i provided above details only for example.