View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Ramage Dave Ramage is offline
external usenet poster
 
Posts: 44
Default 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 ?



.