Sorting
 

I have 9 column headers: Column 1 = Code, Column B = Date, Colum C = Name,
etc. Below Column B dates and sub-headings. After I sort, Col 1 = Ascending,
Column B = Ascending and Col. C = Ascending.

The Problem is, on Col B, the dates are sorted ascensing but the sub-header
(lets say APPLICANTS) will be on the last row (where the last Code 1 on col
A).

I used Descending to sort Col B. The sub-header stays on top BUT THE DATES
are of course arranged descending.

Is there a way to sort Col B so the sub-header will be on top and at the
same time, the dates will be sorted Ascending?

Either select thre radio button for My Data Range has Header Row on the
Sort dialogue box
Or
Mark your range of data from Row2 to the end and select My Data range has No
Header row

--
Regards

Roger Govier


"DAA" wrote in message
...
I have 9 column headers: Column 1 = Code, Column B = Date, Colum C = Name,
etc. Below Column B dates and sub-headings. After I sort, Col 1 =
Ascending,
Column B = Ascending and Col. C = Ascending.

The Problem is, on Col B, the dates are sorted ascensing but the
sub-header
(lets say APPLICANTS) will be on the last row (where the last Code 1 on
col
A).

I used Descending to sort Col B. The sub-header stays on top BUT THE DATES
are of course arranged descending.

Is there a way to sort Col B so the sub-header will be on top and at the
same time, the dates will be sorted Ascending?