Auto Sort info -upon document open

[sarahwilson1000]

I have a document (attached) with sales numbers and I want the rows to auto organize when I open the document. In the row with the total sales I want the highest number to go to the top along with the name and the rank. And so on as the number decreases down the list.

I attached the example document to show you a little more specifically what I am having trouble with. Thanks for the help!


THANKS!

[Marcol]

Try this workbook

Please Login or Register  to view this content.

You might be better with the code in the Worksheet_Activate Module/Event rather than in the Workbook_Open Module/Event

Note the formulae in Columns C & G

[EDIT]
Must be half asleep,
1/. Updated code to work to Last Row in each Table.
2/. Updated Attachment