I have a sheet containing 500 columns each with eight numbered items. I'd like to sort all 500 columns to arrange the items in each from 1-8. Is there a way to accomplish this with a single command versus having to sort each column manually?
I have a sheet containing 500 columns each with eight numbered items. I'd like to sort all 500 columns to arrange the items in each from 1-8. Is there a way to accomplish this with a single command versus having to sort each column manually?
Hi, welcome to the forum
Short answer - no, there isnt.
Longer answer - you could probably do it once and record a macro, then use that from then on. Once you have done the 1st few, you could probably edit the code (and see how it looks/works) and just add the extra columns
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks