C
crossy75
I need to find an easy way to move within the same workbook (but to
different sheets) using the reference of the cell.
ie moving from sheet 1 cell A1 with formula (Sheet2 c3).
the hyperlink formula wants me to put in the file name as well - which
in an existing spreadsheet is quite cumbersome, and time conusming -
and be easier to use the trace dependant button and follow link.
does anyone know of a quick way to do this - i would have thought
excel 2010 would have worked this out!
thanks
Simon
different sheets) using the reference of the cell.
ie moving from sheet 1 cell A1 with formula (Sheet2 c3).
the hyperlink formula wants me to put in the file name as well - which
in an existing spreadsheet is quite cumbersome, and time conusming -
and be easier to use the trace dependant button and follow link.
does anyone know of a quick way to do this - i would have thought
excel 2010 would have worked this out!
thanks
Simon