Sorting Help:I click the header on the column

[Scuba-Steve]

I need to sort a table on 2 levels. I know exactly how to do this one time, but I would like to make it to remain a permenent option when I click the header on the column. Is there any way to do this? I would prefer to not have to use a macro button somewhere else.

[Richard Buttrey]

Hi Steve,

If you don't want macros can't you just use the standard Excel Data Sort functionality, in fact that's the only way without macros.

If you're happy to use a macro visit the thread below and take a look at my response to a similar request a few minutes ago. The macro I offered in that solution will sort a range of data on the column which contains the active cell not just the header cell.
http://www.excelforum.com/excel-gene...y-columns.html

HTH