Hello All,
I have a worksheet of data with the following characteristics:
--column headers
--numeric and textual data
--a "frozen" pane
--some columns in which input is constrained by validation lists stored on
other worksheets within the same Excel file

What I need to do is make it so that each of the main worksheet's column
headers present my Excel-newbie end-users with a simple dropdown/pulldown
that allows them to sort (ascending and descending) all the rows across all
of the columns, i.e. across the frozen pane line, across the validation-list
columns, etc. In an ideal world, users would be able to sort by multiple
columns, i.e. by A then B then C, but I'll happily settle for sorting by one
column.

For the life of me, I can't seem to figure this out. Thanks in advance for
any help -- it's much appreciated.

Jack