Your original description was clear........at least to myself.

That's why you pre-select all columns together before you sort on the one
column.

Name, Race and Sex with stay with Date of Hire row.


Gord

On 20 Dec 2006 18:02:54 -0800, wrote:

It does not bring the other fields with the change. Maybe I did not
make it clear in the posting. When it orders the date of hire i need
the info. in the other columns to move with the correct date.


Gord Dibben wrote:
Just make sure you select all columns before DataSort on Date of Hire column.


Gord Dibben MS Excel MVP


On 20 Dec 2006 15:48:56 -0800, wrote:

I am trying to sort information in excel. Here is an example:

Name Date of Hire Race Sex

I want to sort by date of hire in an ascending order and make the other
information move with the date as it changes. What do I do?

Gord Dibben MS Excel MVP