"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