Thankyou SkipVought and mscallisto. I've incorporated both of your recommendations. Now that I know that it is a snake or newspaper sort. I went one step further and used the microsoft solution and created the macro 'SortAllRangeData'. Secondly I created another macro to run the...
I haven't found a function yet, although it may be simple. I need to sort a set of text values ascending in first column continuing in subsequent columns. The data is restricted to a fixed set of columns and rows.
Although I can copy all values to working column and then sort, I thought there...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.