Sort all columns based on one colum
Greg,
It depends on what values you have in column N other than Yes.
Bernie
"Greg" wrote in message
...
I have column N that has data validation of only "Yes" . i would like to
move
the rows with the "Yes" value in column N to the bottom of the sort.
i have a sort button with this code below. What would i need to insert to
do
this?
Sub SortSunday()
'
'Sort's Sundays Qualifying'
'
ActiveSheet.Unprotect Password:=""
With ActiveSheet
With .Range("B8", .Range("N8").End(xlDown))
.Sort Key1:=.Columns(12), Order1:=xlAscending, _
Key2:=.Columns(11), Order2:=xlDescending, _
Header:=xlYes
ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True, Password:=""
End With
End With
End Sub
Many Thanks in Advance!
Greg
|