Automatically Sort Tables

[Guest]

Is there a way to set a condition to automatically re-sort data as it changes
on a table?

Example:

I have 3 column:
A) Sales agents
B) Items Sold
C) Total Sales in Dollars

the data is being imported into those colums from various sites and
worksheets.
I'd like the 3 colums to automatically sort Hight to Low (Z toA) by Dollar
Amount (column C).

Any suggestions?

 

[Myrna Larson]

How are you importing the data? By macro? If so, the macro can include a
command to sort the data.

 

[Guest]

No, i'm just extracting it from a website.

How are you importing the data? By macro? If so, the macro can include a
command to sort the data.