Good morning
I have a sheet called KPIs with a table of data from B4:M72
What I'd like to do is make all of the headings (B4:M4) into Hyperlinks - so that when you click that hyperlink, it sorts the data by that particular column.
I assume I'll need to use Worksheet_FollowHyperlink - but I'm not sure what the code would be.
Any help, much appreciated!
I have a sheet called KPIs with a table of data from B4:M72
What I'd like to do is make all of the headings (B4:M4) into Hyperlinks - so that when you click that hyperlink, it sorts the data by that particular column.
I assume I'll need to use Worksheet_FollowHyperlink - but I'm not sure what the code would be.
Any help, much appreciated!