I have different pieces of information in each column relating to a single
client eg. A1=job no:, A2=client name, A3=age etc. In the b, c, d, e rows
there are new clients with similiar information. My question is: Is it
possible to "group" all the information in the A row so when I want to "sort
by client name" all the information in the A row will follow its assigned job
no?

At the moment when I want to sort by age, only the "age" column will change
but the other information relating to the client remains static.

Any ideas?

Thanks

You need to select all your data before using Data | Sort
In the Sort Options set the sort for left to right
Please try to use "row" and column" correctly
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email


--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Arderra" wrote in message
...
I have different pieces of information in each column relating to a single
client eg. A1=job no:, A2=client name, A3=age etc. In the b, c, d, e rows
there are new clients with similiar information. My question is: Is it
possible to "group" all the information in the A row so when I want to
"sort
by client name" all the information in the A row will follow its assigned
job
no?

At the moment when I want to sort by age, only the "age" column will
change
but the other information relating to the client remains static.

Any ideas?

Thanks

Select the relevant range of data (rows and columns) before you impose the
Sort command. Don't let Excel guess what you want to include.
--
David Biddulph

"Arderra" wrote in message
...
I have different pieces of information in each column relating to a single
client eg. A1=job no:, A2=client name, A3=age etc. In the b, c, d, e rows
there are new clients with similiar information. My question is: Is it
possible to "group" all the information in the A row so when I want to
"sort
by client name" all the information in the A row will follow its assigned
job
no?

At the moment when I want to sort by age, only the "age" column will
change
but the other information relating to the client remains static.

Any ideas?

Thanks

Gents,
That worked perfectly.

Thank you

"Bernard Liengme" wrote:

You need to select all your data before using Data | Sort
In the Sort Options set the sort for left to right
Please try to use "row" and column" correctly
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email


--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Arderra" wrote in message
...
I have different pieces of information in each column relating to a single
client eg. A1=job no:, A2=client name, A3=age etc. In the b, c, d, e rows
there are new clients with similiar information. My question is: Is it
possible to "group" all the information in the A row so when I want to
"sort
by client name" all the information in the A row will follow its assigned
job
no?

At the moment when I want to sort by age, only the "age" column will
change
but the other information relating to the client remains static.

Any ideas?

Thanks