Automatically Sort Tables
 

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?

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

On Tue, 22 Mar 2005 06:07:03 -0800, "tamato43"
wrote:

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?

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

"Myrna Larson" wrote:

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

On Tue, 22 Mar 2005 06:07:03 -0800, "tamato43"
wrote:

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?