Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically Sort colums | Excel Discussion (Misc queries) | |||
How do I sort a list automatically? | Excel Discussion (Misc queries) | |||
how do i automatically sort a list | Excel Worksheet Functions | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
sort automatically | Excel Worksheet Functions |