Excel 2007, Sort by Title Button

[DavidCrj]

I'm currently switching a Windows Access file to Windows Excel 2007.

The file is a list of:

Defendant: Plantiff: Court: Date:

I want to be able to make those titles into a button, where I can click, and it will auto-sort the values from A->Z or in number order (dates from January->December)

Is there a way to add this? I do have the developer ribbon already.

Thanks for any help!

-Helpless in NY
DavidCrj

 

[jrdnoland]

Once you have the table imported into excel, replace the header titles with ActiveX command buttons. You can name the command buttons and change the caption to something like:

Name = cmdSortDefendant
Caption = Sort A-Z By Defendant

Run the macro recorder to get the code for each one and then cut and paste it into the click event of the command button.

I'm making some assumptions that you understand a little about programming with vba and Excel; if not let me know and I can give you more of a step by step approach.