I'd add a commandbutton that sorted based on selection.column. That
way, they select the column they want (or they select a cell in the
column they want), click "sort" and bob's your uncle.

But I'm having trouble imagining something much simpler than the
regular Sort tool.

If you want something REALLY simple, you could set something up that
copies the spreadsheet across 48 sheets, each one named for a column,
and sorts it by that column, then stick a userform or something that
will activate the sheet they want and hide all the other ones.

Just a couple of ideas...

Tsunami3169 wrote:
Hello everyone, I'm setting up a metrics spreadsheet with many columns.
The spreadsheet has business data for 2006 and 2005. Also the variance
between the two. To make life easier for Senior Management I need to
provide a way for them to sort the data with minimal steps. Any
suggestions? The spreadsheet only has 48 columns and they need the
ability to sort on any of these columns.

Thanks for any help and suggestions in advance.