Hi all,

Can anyone help me.
I have a huge table, full of data
To see the data I use 5 different worksheets referencing this table.
When Im in one of these worksheets, I see some data I want to change,
dont want to have to spend ages going to my main data table, searchin
for the right place and editing. I would like to select a cell in
worksheet, and for a macro (when I hit Shift F1 say) to place th
cursor in the location that was referenced from that cell.

This would be really useful, any ideas and help greatly appreciated.
Best regards
Tim Ge

--
Message posted from http://www.ExcelForum.com

Press Ctrl-[

Tim,

Put this code in a macro and use that

If ActiveCell.HasFormula Then
Application.Goto Reference:=Range(Mid(ActiveCell.Formula, 2, 99))
End If

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"timspin " wrote in message
...
Hi all,

Can anyone help me.
I have a huge table, full of data
To see the data I use 5 different worksheets referencing this table.
When Im in one of these worksheets, I see some data I want to change, I
dont want to have to spend ages going to my main data table, searching
for the right place and editing. I would like to select a cell in a
worksheet, and for a macro (when I hit Shift F1 say) to place the
cursor in the location that was referenced from that cell.

This would be really useful, any ideas and help greatly appreciated.
Best regards
Tim Gee


---
Message posted from http://www.ExcelForum.com/