Auto sort by clicking on a column heading

[cpaavola]

Hey all, this is a doozy.

If I have a list of information that I want to allow other users (with little to no Excel experience) quickly sort data by clicking on the head of a column, how would I do that?

For instance, here is a snippet of what is actually a huge list of employees that some key stake holders need to see. I'd like if they could click on the column heading and sort by that column... is it possible WITHOUT going to Data > Sort?

Employee	Units sold	Bonus Sales	Package Sales	New customers
A	145	33	22	4
B	143	41	26	4
C	141	29	14	6
D	138	42	30	4
E	133	33	18	4
F	129	29	22	4
G	126	40	22	4
H	123	35	24	3
I	116	48	22	4
J	114	44	20	3

<tbody>
</tbody>

 

[pplstuff]

Click the cell Employee, go to your ribbon and hit filter (in the data tab) - should do it automatically.

 

[JoeMo]

Here's a macro you can put into the sheet that your data is on. Macros must be enabled to use this and if you are using Excel 2007 or later version, the workbook must be saved with a .xlsm or .xlsb extension. To install the macro: open the workbook, right-click the sheet tab and choose 'View code', then paste the code below into the white space in the VB editor that opens. Close the editor and save the file (with the correct file extension).

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.CurrentRegion.Count = 1 Then Exit Sub
If Target.Row > Target.CurrentRegion.Rows(1).Row Then Exit Sub
With Target.CurrentRegion
    .Sort key1:=Target, order1:=xlDescending, Header:=xlYes
End With
End Sub