CellA1 has ='Corridor Select- Input'!C5.
.. to auto go to that linked source
Tinker with this:
Select A1
Click Tools Auditing Trace Precedents
Double-click on the dotted arrow / little sheet icon
to bring up the "Go to" dialog, then just either
double-click on the link in the box (or select it and click OK)
which will zap you straight to: 'Corridor Select- Input'!C5
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jaylin" wrote in message
...
I have created some link formula,
Example
CellA1 has ='Corridor Select- Input'!C5.
I was told by a colleague that there is a function
in excel that allows me to auto go to that linkd source.
ie if I double click on Cell A1, I can
automatically go to Sheet"CorridorSelect-Input" Cell C5.
I have tried doing that but it does not work.
Just wondering if I am doing anything wrong.
--
Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******