I'm familiar with the typical sort functions where you sort the order of the rows based on the values.
However I am having real trouble changing the order of columns based on the value of headers.
Can anybody point me in the right direction?
Thanks
GG
Last edited by Granite-Granny; 07-14-2014 at 04:13 PM. Reason: typo
When sorting, click on options and choose left to right.
Martin
Click on Sort icon | Custom Sort | Options | Left to Right | Row 1
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Ah ha. Thanks.
I ended up with this code after figuring out the correct syntax with record macro:
Thanks
Please Login or Register to view this content.
GG
Last edited by Granite-Granny; 07-14-2014 at 04:59 PM. Reason: typo
You're welcome. Thanks for the rep.
No problem man. The other thing I just found out is that excel goes a bit crazy if you have two sorts, one top to bottom followed by one left to right.
In the first sort command I didn't specify orientation:=xltoptobottom assuming it would be the default. Every second time I ran
the macro the sort would get all jacked up. It took me about half an hour to figure out that if you don't specify the orientation
it defaults to what was last done i.e. lefttoright!
Silly computer program!
GG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks