Sorting 100 rows of 6 records horizontally
I would like to sort the 6 records in each separate row (100 total) ascending.
Is there a built-in function to do that.
I tried to use the macro recorder to sort the rows manually but 100 is too tedious, I would appreciate any hints for a killer macro..
TIA
|