Can you make a "Sort By" link?

will_tut

New Member
Joined
Oct 14, 2002
Messages
1
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?
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
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

Well-known Member
Joined
Jul 24, 2002
Messages
1,606
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

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
Ah, sorry. I'd gotten myself confused when reading that. (been one of those days--stupid allergies)
 

Forum statistics

Threads
1,144,510
Messages
5,724,774
Members
422,576
Latest member
kayth891

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top