Uh. I thought perhaps you were unaware that all you have to do is select one cell and click one button. Some people sort using a longer technique.

Hi,
I am more a "formula expert", but I looked around a little, stole some code and modified it

Here we go:
Right click the sheet tab. Select "View code".
Paste the code below. Modify sort column if wanted (A1 at the moment). Leave with Alt+Q.
Done!

Kind regards
Bjorn

Private Sub Worksheet_Change(ByVal Target As Range)
'Sort this sheet by column A
'Written by OzGrid Business Applications
'www.ozgrid.com
'small modification by Bjorn 2010-10-02

On Error Resume Next
Application.EnableEvents = False
Me.UsedRange.Sort _
Key1:=[A1], Order1:=xlAscending, Header:=xlYes, Orientation:=xlSortColumns
Application.EnableEvents = True
On Error GoTo 0

End Sub

No luck, man. Maybe it's because I didn't change the sort column (How do I?), but upon opening and closing, all the data remains the same.

Hi,
try replacing A1 with C1 in the macro, since you like to sort column C (which contains the supplier).

Kind regards
Bjorn