Can you make a "Sort By" link?

[will_tut]

I have a large spreadsheet, made up of 4 columns (lastname, firstname, date, and position). I originally had 4 different sheets, and each one had all the info sorted by one of those data types. Is there any way to have 1 sheet with all the info, and links that you can click to sort the info? For instance, I'd love to be able to click on the "Last Name" link and have it sorted alphabetically by last name. Any ideas?

 

[Von Pookie]

Autofilter, maybe?

 

[Mark W.]

On 2002-10-15 14:32, Von Pookie wrote:
Autofilter, maybe?

AutoFilters don't sort.

 

[Mark W.]

On 2002-10-15 14:29, will_tut wrote:
I have a large spreadsheet, made up of 4 columns (lastname, firstname, date, and position). I originally had 4 different sheets, and each one had all the info sorted by one of those data types. Is there any way to have 1 sheet with all the info, and links that you can click to sort the info? For instance, I'd love to be able to click on the "Last Name" link and have it sorted alphabetically by last name. Any ideas?

Have you tried using the Data | Sort... menu command or a Sort Ascending/Descending toolbar button?

 

[royUK]

Use the MacroEditor to create your Macro. Choose create new macro from the Tools Menu>Macros and proceed to perform your sort.
Then Stop Recording. You now have a Macro to perform your sort. Add a button from the Forms Menu and attach your Macro. You can repeat this for other "sort bys"

 

[Von Pookie]

Ah, sorry. I'd gotten myself confused when reading that. (been one of those days--stupid allergies)