Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Click Button to Load External Data Into Spreadsheet | Excel Programming | |||
after click a button(commandbutton), getting the button name | Excel Programming | |||
1 click sorting *almost there* | Excel Programming | |||
Create floating button based on button click in menu | Excel Programming | |||
VBA button click need help. Need LEN help. | Excel Programming |