Sorting data on button click

[John]

Hi guys !

I have one sheet with cca 400 rows, divided in columns like name, date,
location, number etc.

Now, what i want to do is to create something like in windows explorer.
One "menu" where you can click on name, size, type, date modified etc.
and on click, columns should be sorted ascending or descending. The same
as in windows explorer....

How to make this ?

 

[Dave Ramage]

John,

You can do this by applying the autofilter to the sheet. Select a cell in
the region of the list/table and click Data/Filter/AutoFilter. You now have
dropdowns for each column. If you scroll up the dropdown you'll see sort
options (v2003+).

Cheers
Dave

 

[Dave Peterson]

Check your other post.

Hi guys !

I have one sheet with cca 400 rows, divided in columns like name, date,
location, number etc.

Now, what i want to do is to create something like in windows explorer.
One "menu" where you can click on name, size, type, date modified etc.
and on click, columns should be sorted ascending or descending. The same
as in windows explorer....

How to make this ?