Hi everyone!
I have 2 sheets (see below).
If I click on any number in my sheet1 first column, I'd like to be able to directly jump/go to the corresponding same number in my sheet2 (and vice-versa - toggle).
Example:
If I click on #3 in sheet1 (row4), then Excel directly goes to/position itself to #3 in sheet2 (row6).
Now sheet2 is active, if I click on #4 (row7), sheet1 becomes active and its cursor is directly positionned row6, in cell #4 in sheet1.
I have asked Google, read the documentation for hours but haven't solution yet, I'm afraid my Excel level is too low... I don't even know if it's possible !?! ... so any help is welcome.
Happy new year & Thanks!
sheet 1
<tbody>
</tbody>
sheet 2
<tbody>
</tbody>
I have 2 sheets (see below).
If I click on any number in my sheet1 first column, I'd like to be able to directly jump/go to the corresponding same number in my sheet2 (and vice-versa - toggle).
Example:
If I click on #3 in sheet1 (row4), then Excel directly goes to/position itself to #3 in sheet2 (row6).
Now sheet2 is active, if I click on #4 (row7), sheet1 becomes active and its cursor is directly positionned row6, in cell #4 in sheet1.
I have asked Google, read the documentation for hours but haven't solution yet, I'm afraid my Excel level is too low... I don't even know if it's possible !?! ... so any help is welcome.
Happy new year & Thanks!
sheet 1
1 | |
2 | |
3 | |
4 |
<tbody>
</tbody>
sheet 2
1 | |
2 | |
3 | |
4 | |
<tbody>
</tbody>