Reposted as I might have been in the wrong newsgroup.

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