Sorting data on button click
 

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 ?

Sorting data on button click
 

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

"John" wrote:

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 ?



.

Sorting data on button click
 

Check your other post.

John wrote:

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 Peterson