I have spent today searching and have seen LOTS of messages about hyperlinks, but I have not been able to understand enough to adapt/create my own answers
I have a workbook with many sheets, an each sheet there are several/many formulae which dispaly values from other sheets within the same workbook.
In a cell next to the formula I have manually added hyperlinks to the formula's-data-source.
The workbook is now cluttered with my hyperlinks; which also break down whenever I add a new row or column.
I have been reading about Dynamic-hyperlinking, but have not been able to get it to work;
Perhaps hyperlinking is a wrong approach?
I am looking for a way to:-
Click on the cell containing the formula, and then auto-jump to the source-data of the cell/formula?
select a cell; and run a macro shortcut which would check the formula within the active cell and then jump to the source-data.
create a hyperlink formula which would read the formula of the cell next to it, and provide a hyperlink to that formula's-data-source
can anyone help?
(Is is possible to add a macro-shortcut to the mouse's right-button-click menu?)