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

[Guest]

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.

 

[Fredrik Wahlgren]

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.

Use Data|Sort.

/Fredrik

 

[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