Is it possible to add a macro to a hyperlink.
I have a formula on a 'menu' page which gives a figure from selected data on
a different worksheet. (I have quite a few).
I am looking at a way that you can click on that number and it takes you to
the worksheet, but then it sorts the data as defined by a filter, i.e.
selects all the records with London in them.

So whichever number you click on, you only see the data associated to that
figure.

Any ideas not using VB would be appreciated.

Thanks

It is possible to have a macro executed when you click on a hyperlink. But
that would involve VBA.
--
Gary''s Student - gsnu200827


"Mick" wrote:

Is it possible to add a macro to a hyperlink.
I have a formula on a 'menu' page which gives a figure from selected data on
a different worksheet. (I have quite a few).
I am looking at a way that you can click on that number and it takes you to
the worksheet, but then it sorts the data as defined by a filter, i.e.
selects all the records with London in them.

So whichever number you click on, you only see the data associated to that
figure.

Any ideas not using VB would be appreciated.

Thanks