Your need to use a helper column for sorting which identifies each group
uniquely ..........

Vaya con Dios,
Chuck, CABGx3


<Akber Khan; <Karachi; "Pakistan"
m wrote in message
...
Thank for your reply

But when we sort by selecting range it mix all the rows in order to give
the
desire result, i want to keep certain rows togather. i hope u understand

"Akber Khan, Karachi, Pakistan" wrote:

Working on a excel sheet maintaining huge data and need to sort it date
wise,
amount wise (range 1 to 10000, 10001 to 20000).

The problem is that we have data set of different clients, this data set
of
each client spread over 9 columb and 7 rows and i need to sort it in a
group.

How do i do this?
Data set should'nt be destroy?



for example
Columbs a

Name of Client nature of business funded non funded
trade
business date of approval limit expiry date fresh/renewal
remarks.

rows a
DM
MMF
IERF
BD/RISK LINE
PAD
OTHERS
SUBTOTAL