I would like to have a button or a link on my spreadsheet that when it is clicked will sort my table with a pre-defined sort.
Is there a way to do this?
g
I would like to have a button or a link on my spreadsheet that when it is clicked will sort my table with a pre-defined sort.
Is there a way to do this?
g
Last edited by Patchworks; 07-13-2009 at 07:22 AM.
Yes. Record a macro going through all of the steps of applying the sorting.
Next, create a button object from the Forms controls and assign the macro to this button.
The resulting VBA code won't be the most efficient, but you can post it and someone will help refine it for you.
Suggestion: create a dynamic named range to be used as the sort range so that as data is added or deleted your range reference in the VBA will always be current. The dynamic named range will have to be hand coded into the macro.
Thanksk bud!!
Worked perfect!!
g
You're quite welcome.
Used to live in Houston. Man, do I miss getting some good beef brisket!![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks