On Mon, 27 Mar 2006 04:44:35 -0600, popunonkok
wrote:


I have a problem in Excel that I hope someone can help me with.

I have a sheet that looks like a data base, id number, name, age, city
is the kolumns name.

Now i would like the same information on a different sheet but in a
different order. (kinda like the sort function). In this sheet I would
like every information but the people sortet by the city, everybode
from the same city.

I could just write every new "member" twice, in eatch sheet and then
sort sheet number two in that order. But I dont want to do this... :)

Please help me...

Select the entire table on OldSheet.
Copy to NewSheet
On NewSheet, Data/Sort
by City (Ascending)
by Name (Ascending)


--ron