tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,197
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I have a range of 10 rows
AA11:AZ21
AA11 :AA21 is the headers, with the data going along the rows.
I want to do a data sort macro that will sort the ten rows right to left (first alphabetically to last)
now my ideal situation would be this
I have 20 small shapes as buttons each call "ONbt" or "OFFbt" (With a number 1 to 10 so first is "Onbt1"
now if we select an "ONbt" button then it sorts by that row, then if i press a second "ONbt" it sorts by that row also, and so on.
pressing any OFFbt will clear all sorts. (but i can do that part )
So if the above is not possible or two complex just the code to sort left to right will be a big help
Thanks
Tony
I have a range of 10 rows
AA11:AZ21
AA11 :AA21 is the headers, with the data going along the rows.
I want to do a data sort macro that will sort the ten rows right to left (first alphabetically to last)
now my ideal situation would be this
I have 20 small shapes as buttons each call "ONbt" or "OFFbt" (With a number 1 to 10 so first is "Onbt1"
now if we select an "ONbt" button then it sorts by that row, then if i press a second "ONbt" it sorts by that row also, and so on.
pressing any OFFbt will clear all sorts. (but i can do that part )
So if the above is not possible or two complex just the code to sort left to right will be a big help
Thanks
Tony