Hello all,

I am a pretty big n00b when it comes to Excel, so bear with me here. I am on Mac OS X, and we are running Office 2004.

I work for a magazine publisher, and need to keep track of who we charge when they send in an ad wrong. Basically, I have a workbook with 4 sheets. Each one is basically the same thing, just with different categories (Decor, Industrial, Salon, Food 360) -- but still need to be auto sorted and updated dynamically. Column A is the name of the publication, column B is the issue date, column C is the name of the advertiser, and there are 5 more columns that are also in the sheets that I don't need sorted.

What I have filled in each is just fake info and just to get things working.

What I want done, is basically an automatic version of what happens when I hit "Sort": I have made a macro of this, and figured I could automatically have the macro run any time I add/change a new row/info. This macro looks like this:

Sub AutoSort()
'
' AutoSort Macro
' Auto Sorts columns
'
' Keyboard Shortcut: Option+Cmd+s
'
    Range("A5:H35").Select
    Selection.Sort Key1:=Range("A5"), Order1:=xlAscending, Key2:=Range("B5") _
        , Order2:=xlAscending, Key3:=Range("C5"), Order3:=xlAscending, Header:= _
        xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub
My questions is, how do I do this so that each sheet, when adding a new row of info, will dynamically and automatically sort alphabetically/numerically like that "Sort" macro?
Hope this makes sense! It's been driving me nuts!!!

Thanks in advance,
Josh