defining the header row & "end" of spreadsheet

[Margorita]

I am working on a list and I want to sort it various ways.

I have names on each of my columns (like account id or date purchased) but have not made them "NAMES" or "LABELS" or anything else.

I have formatted them to be displayed at an angle and in bold text.

Now when I sort, it ALWAYS defaults to no header row.

is there anyway to define what the default is in this box, so that it always thinks there are header rows,

or

is there a way to define the header rows?

Also, when you use CTRL + END is there a way to define what is the last cell in your spreadsheet?

Thanks

Lisa

 

[venkat1926]

Take this example

IsoTrain 25Aug06
I don’t know whether your dates are parked in separate column and whether they re entered as dates and not as text
Suppose the above date is in B2
Now
=month(B2) will give you 8
You can use this as criteria either for filtering or doing sum if or sumproduct.

In vba you can wrie

If month (some range)=8, then (that cell.entirerow. copy) and another destination cell.

These are only some approach to the subject.