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.

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.

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.