View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default ?? Auto go to link source

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*******