Auto Sorting based upon 3 columns? (Mac 2004)

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:

Please Login or Register  to view this content.

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

Well, I figured it out... This only took about 4-1/2 hours... LOL! I used this code on each Worksheet in the VBR editor:

Please Login or Register  to view this content.

And with this Macro:

Please Login or Register  to view this content.

This seems to work, and it now autosorts dynamically based upon mainly the first column (publication name), followed by the second column (date), then the third column (advertiser name).

Hopefully this can help any others in the future.