Cells: A4 = Extravert A5=Intravert A6=Passive A7=Other

Cells: A1 - A800 are the clients names,

These statements conflict.
------------------------------------------------------
I would like to is be able to sort on each customer row A4 - A7 based on the
answers 1 - 4.

Only sort on four rows?
-------------------------------------------------------------
So for example if Client #1 said 1 to a4, 2 to a6, 3 to a5,
and 4 to a7, then it would put data in that order and keep the title because
I am using the title on another page

What titles? Row 1 was a name and column A seems to be names.

-------------------------------------------------------------------------

You need to clean this up and repost.



'
"MLewis123" wrote in message
...
I am certain someone can help me here. To start off lets assume you have
something that looks like this:

Cells: A4 = Extravert A5=Intravert A6=Passive A7=Other

Cells: A1 - A800 are the clients names, so A1 = Client #1, A2=Client #2,
and
so forth. Each client answers a number 1 to 4 for the above A4 - A7. Now
what
I would like to is be able to sort on each customer row A4 - A7 based on
the
answers 1 - 4. So for example if Client #1 said 1 to a4, 2 to a6, 3 to a5,
and 4 to a7, then it would put data in that order and keep the title
because
I am using the title on another page. I realize I might need to create
more
columns which is fine. Any thoughts on a formula?