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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - I have a master list can I get office to orangnize by city for me. (https://www.excelbanter.com/excel-worksheet-functions/21528-i-have-master-list-can-i-get-office-orangnize-city-me.html)

David

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

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

"David" wrote in message
...
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

DataFilterAutofilter 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

On Mon, 11 Apr 2005 13:25:03 -0700, "David"
wrote:

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.

All times are GMT +1. The time now is 01:30 AM.