Thread: Sort pages?
View Single Post
  #3   Report Post  
Old May 12th 05, 12:40 AM
CLR
 
Posts: n/a
Default

Use a Helper column with the Name and a suffix of a sequential number, like
Brown,Charlie1 for row one of Charlie Browns data, then Brown,Charlie2 for
his second row, etc etc........then Armstrong,Jack1....Armstrong,Jack2 for
the next group etc etc...........they don't have to be sorted by name, then
sort on this column and they sort as a group by name, and stay in the proper
order as well..........

Vaya con Dios,
Chuck, CABGx3


"David" wrote in message
...
Using XL2000:

I have a single page spreadsheet (needed for SubTotal() to work),

separated
into 65 sheets via Page Break Preview. The top cell of each page in Col A
contains the student's name (last name, first name). If I add a student,
how can I then sort the pages by the student's last name?

Acceptable alternative: Have each student on their own page with sheets
named Lastname Firstname, sort those, and still be able to Subtotal in
cells on those sheets, then Grand Total on a separate sheet.

--
David