If you've setup your autofilters correctly, you can simply use the sorting
capability listed within the filter.

But yes, you could create a button from the forms toolbar (or a picture, if
you like) and assign a macro to either of them.

--
Best Regards,

Luke M
"akkrug" wrote in message
...
What is the best way to sort a spreadsheet? My boss wanted filters set
up,
so I set up an autofilter for all columns. She also wanted to sort by one
column, so I recorded a macro that sorted the column in ascending order
and
another macro to sort it into descending order. I thought there might be
a
better way to do it. Also, can I assign the macro to a button instead of
a
shortcut key?

Thanks for the help!!

Ken
--
akkrug