A reference snippet on how to apply filter the spreadsheet on for a predetermined column.

[sourcecode language=”csharp”]
Option Explicit

Public Sub OrderColumn()
With ActiveWorkbook.Worksheets("Juice")
If .AutoFilterMode Then .AutoFilterMode = False
With Range("B2")
.AutoFilter
.Sort Key1:=.Range("A1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End With
End With
End Sub
[/sourcecode]

You can download this macro workbook from this link.

A vlog demo to go with it.

n1849778
About the
I am a software developer in Calgary, Alberta, Canada with passion in getting my fingers in any new technology. I started software development when I was 10 years old and have never looked back. Now with well over 35 years of software development, I wanted to share some of these key knowledge with the people of the world in the wide web.