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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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
 
Back
Top