Turn on the macro recorder while you do it manually. then turn off the macro
recorder when you are done.

That should give you the basic code you need.



--
Regards,
Tom Ogilvy


"Barry Walker" wrote:

Thats what I used to do anyway, but i just wanted to make it simpler that
that so that as soon as it was downloaded and moved into the new ex cel
spread sheet it would automatically do all of those things without me having
to.

Thanks though

"SyrNO" wrote:

Here's another way you can try, Barry:

Click on any value in the Company column and Sort Ascending (A--Z)
Then go to Data Menu -- Subtotals. Indicate at each change in company, you
wish use a specified function on a selected column of data.

"Barry Walker" wrote:

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