I have a master list can I get office to orangnize by city for me.

D

David

I have a master customer list on a excel sheet can I get excel to oragnize it
by city for me on anther excel sheet? Right now all of the cities ale
together I would like to have all acounts on the same state on one sheet.
 
F

Fredrik Wahlgren

David said:
I have a master customer list on a excel sheet can I get excel to oragnize it
by city for me on anther excel sheet? Right now all of the cities ale
together I would like to have all acounts on the same state on one sheet.
Click to expand...

Use Data|Sort.

/Fredrik
 
G

Gord Dibben

David

Data>Filter>Autofilter by a particular state then copy results to another
worksheet.

OR sort by state then copy the results to new sheets.


Gord Dibben Excel MVP
 
Top