Dear Senior members, i have a data containing on about 10,000 rows which
consists the following heads S.No. Name of person, Address, Telephone No.
and mobile No. I have to sort out this data on the basis of areas which is
divided into 5 catageries on the basis of addresses. Please help to sort out
the same.
Khawaja Anwar

With no idea of how your data is laid out, I would hazard a guess that
Autofilter might do the job to separate into the 5 categories based on
addresses.

Each set of those filtered results could be copied to another sheet.


Gord Dibben MS Excel MVP

On Fri, 28 Mar 2008 21:52:00 -0700, Khawajaanwar
wrote:

Dear Senior members, i have a data containing on about 10,000 rows which
consists the following heads S.No. Name of person, Address, Telephone No.
and mobile No. I have to sort out this data on the basis of areas which is
divided into 5 catageries on the basis of addresses. Please help to sort out
the same.
Khawaja Anwar