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