Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel
I have a main sheet that is in zip code order.
Is it possible to have another sheet that gets the info from the main sheet, but is sorted by name. |
#2
|
|||
|
|||
Yes.
FIrst select all the cells in the main sheet that contain data and copy them. Next go to the other sheet and paste the data. Finally sort the data in the other sheet by name rather than number -- Gary's Student "Larry" wrote: I have a main sheet that is in zip code order. Is it possible to have another sheet that gets the info from the main sheet, but is sorted by name. |
#3
|
|||
|
|||
Thanks for the reply. What I want to avoid is the copy, paste, and sort to
the 2nd sheet. I was thinking there might be a way of automatically copying sheet1 to sheet2 with some kind of lookup function on sheet2 and having it displayed in a different column sort. Larry "Gary's Student" wrote: Yes. FIrst select all the cells in the main sheet that contain data and copy them. Next go to the other sheet and paste the data. Finally sort the data in the other sheet by name rather than number -- Gary's Student "Larry" wrote: I have a main sheet that is in zip code order. Is it possible to have another sheet that gets the info from the main sheet, but is sorted by name. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |