'Follow through' a forumal and highlight respective cells

[CraigPearman]

HELP!

It would really make my life easier if there was a shortcut which allowed me to follow through a formula and took me to the cell that it is pointing to.

More detail - so I have a spreadsheet with two tabs. One tab (called Costs) has formulas in it, one with data (called SAP). The formulas point to the data. An example of a formula used in the Cost tab is =SUM(SAP!T102+SAP!T109+SAP!T110)

I am aware of the shortcut CTRL+[ which does allow me to 'follow through' to that cell on the linked tab, however where there are numerous cells (as in formula above) it only ever sends me to the first cell (SAP!T102 in my example)

Ideally I would like it to highlight all three cells

Any ideas?

[MarvinP]

Hi Craig and welcome to the forum,

Look at step 4 on
http://www.bettersolutions.com/excel...c726826332.htm

Double clicking the arrow brings up a Go To Dialog box.

This seems to be the best you can do without some VBA code or something to background color the correct cells on the other sheet.