help on sorting data

Hi,
I have a soccer grid result. So I would like the column corresponding
to the points of the teams sorted descending. But I want the other
column to follow. And I want the first column (rank) to remain still
and not affected by the sorting operation. How can I do that ?

thx

Just select the columns you want to sort, and then sort.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Sam" <[email protected]> wrote in message
news:[email protected]...
> Hi,
> I have a soccer grid result. So I would like the column
> corresponding
> to the points of the teams sorted descending. But I want the
> other
> column to follow. And I want the first column (rank) to remain
> still
> and not affected by the sorting operation. How can I do that ?
>
> thx
>

thx
actually i've managed to do that
but how do i do it programmatically, that is in a macro ?
How do I refresh the sheet ?

tx

If you record a macro when you do it manually (once), you'll see the basic code.

If you need help modifying it, post back with the code you recorded.

Sam wrote:
>
> thx
> actually i've managed to do that
> but how do i do it programmatically, that is in a macro ?
> How do I refresh the sheet ?
>
> tx

--

Dave Peterson