Sorting data from one sheet to another

K

Khawajaanwar

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searching data 0
Sorting multiple columns that have similar data 0
Maintaining groups of data (2003) 0
copy rows from one Data sheet to another sheet based on cell conte 2
How do I stop a Pivot Table from Sorting my data (Excel 2007) 1
sorting data from one table/range to another table/range 1
Converting this raw data into something formulaic 4
Reading data from one sheet into another sheet 1

Top