Barry,

Don't sort. In fact, don't do anything to your input data. Simply use a Pivot table based on your
database, and use the Pivot table can create the totals that you are interested in.

HTH,
Bernie
MS Excel MVP


"Barry Walker" wrote in message
...
Each month I have to download a spreadsheet containing many columns of
information. When I save it, I normally do so as an excel document, then i
spend time sorting it out for analysis. This is time consuming and i'm
looking for a way of downloading into a spread sheet that automatically sorts
it the way I want it to and deletes unwanted columns and then totals a
particular column.

The information is sorted as follows. The spreadsheet comes up with
a random list containing information on 3 companies. I want it to sort into
company order so,

Company 1
Company3
Company3
Company 2
Compamy 1
Company 2

Becomes

Company 1
Company 1

Company 2
Company 2

Company 3
Company 3

The only reason I sort it is since it makes it easier to total the figures
for each company.

It does not matter what this spreadsheet looks like so a simpler way could
be for Excel to detect a particular company and total the values
corresponding to the particular company and automatically imput them into a
seperate box.

Can anyone help?

Kind Regards

Barry