I have a worksheet that has 6 columns that need to be sorted alphabetically the same time. As far as I know Excel’s Sort function only allows 3 columns at the time. How do I sort 6 columns the same time? Need help urgently. Thanks.
That’s what I mean by sorting 6 columns by using them as the sort criteria for all 6 columns.
I have tried to sort them in steps, but the second sort will change the first sort’s order.
Any suggestion of how to write the code? Thanks.