Chanzuihou
New Member
- Joined
- Jul 28, 2016
- Messages
- 19
Hi everyone,
At work, I've encountered a task and would greatly appreciate anyone's valuable help.
One of my data sheet is quite a long one, ie from column "A" to column "VV", that means lots of navigating every time when I want to find a specific area (horizontally), which is a bit painful.
The data is structured into a few blocks, ie in my attached test Excel file, they are AAA, BBB, CCC and DDD in the tab "Data".
I 've created a drop down list in cell A1 in "Data" sheet, and also I've created hyperlink, linking to the desirable location in tab "List". I also put hyperlink formula in B1 next to A1, I was hoping every time when I select a value in A1, B1 can update hyperlink, so when I click B1, it takes me to the desirable cell location.
Is this achievable at all? Thanking everyone in advance and very much appreciate it
Best regards
Excel 2012
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
Excel 2012
<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
</tbody>
At work, I've encountered a task and would greatly appreciate anyone's valuable help.
One of my data sheet is quite a long one, ie from column "A" to column "VV", that means lots of navigating every time when I want to find a specific area (horizontally), which is a bit painful.
The data is structured into a few blocks, ie in my attached test Excel file, they are AAA, BBB, CCC and DDD in the tab "Data".
I 've created a drop down list in cell A1 in "Data" sheet, and also I've created hyperlink, linking to the desirable location in tab "List". I also put hyperlink formula in B1 next to A1, I was hoping every time when I select a value in A1, B1 can update hyperlink, so when I click B1, it takes me to the desirable cell location.
Is this achievable at all? Thanking everyone in advance and very much appreciate it
Best regards
Excel 2012
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | AAA | Go | AAA | BBB | CCC | DDD | ||||||||||||
2 | ||||||||||||||||||
3 | ||||||||||||||||||
4 | ||||||||||||||||||
5 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Data
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>
Excel 2012
A | |
---|---|
1 | Division |
2 | AAA |
3 | BBB |
4 | CCC |
5 | DDD |
6 | |
7 |
<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
</tbody>
List