Hello All,
Its regarding Hyperlink in Ms 2013. I have two sheets names
Sheet 1-Devices
Sheet 2-Switches
In Devices sheet, i have A1 with the some no. (ex:1010)
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
In Switches sheet, I have a list of some details regarding Sheet 1 (Device)
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Now my question is can we automaticly search for the hyperlink from Sheet 1 to sheet 2. Like when i click on 10101 in Sheet 1 it has to jump into sheet 2 to A3. I cant map maually becuase i have to do it 1000+ cells.
Thanks in advance.
Its regarding Hyperlink in Ms 2013. I have two sheets names
Sheet 1-Devices
Sheet 2-Switches
In Devices sheet, i have A1 with the some no. (ex:1010)
A | |
1 | 10101 |
2 | 10102 |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
In Switches sheet, I have a list of some details regarding Sheet 1 (Device)
A | B | |
1 | 10106 | 12 |
2 | 10110 | 13 |
3 | 10101 | 14 |
4 | 10104 | 15 |
5 | 10102 | 16 |
6 | 10109 | 17 |
7 | 10108 | 18 |
8 | 10107 | 19 |
9 | 10105 | 20 |
10 | 10103 | 21 |
11 | 10111 | 22 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Now my question is can we automaticly search for the hyperlink from Sheet 1 to sheet 2. Like when i click on 10101 in Sheet 1 it has to jump into sheet 2 to A3. I cant map maually becuase i have to do it 1000+ cells.
Thanks in advance.