Database/sorting

[BKG SPORTS]

excel 2007

I'm putting together a database, and I want it so when I click on a
column, it sorts automatically

any idea's

Thanks
BKG

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Static MySortType As Integer
If MySortType = 0 Then
    MySortType = xlAscending
ElseIf MySortType = xlAscending Then
    MySortType = xlDescending
ElseIf MySortType = xlDescending Then
    MySortType = xlAscending
End If
Target.CurrentRegion.Sort key1:=Target, order1:=MySortType, Header:=xlYes
Cancel = True
End Sub

Double click a column to sort. Double click again to reverse.

 

[BKG SPORTS]

Thanks VOG, that worked out great