| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
"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 |
|
#3
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| Master List Losing Record Due to Update from Links | New Users to Excel | |||
| Insert column entries from a master list | Excel Worksheet Functions | |||
| Insert column entries from a master list | Excel Worksheet Functions | |||
| Insert column entries from a master list | Excel Worksheet Functions | |||
Linear Mode
