Clicking a cell...... automatically to another cell?

  • Thread starter Thread starter Ruud
  • Start date Start date
R

Ruud

Is it there a formula, that if you click on a Cell,
you automatically go to another Cell in that worksheet?
(without using a macro?)

Ruud
 
You could also use an =hyperlink() formula.

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)
 
Dave,
Works perfectly! Thank you
Ruud



Dave Peterson said:
You could also use an =hyperlink() formula.

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)
Click to expand...
 
Back
Top