Automatically Sort Tables

T

tamato43

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?
 
M

Myrna Larson

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

tamato43

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

Myrna Larson said:
How are you importing the data? By macro? If so, the macro can include a
command to sort the data.
 
Top