I figured out how to in VBA: import an excel file, remove/add indexes, add/delete columns/records. What I am looking for is to sort the table by columns.
First sort by column 1, then sort by column 2, then by column 3, then by column 4 and save the table in that manner, or write to a new table.
Should I remove all indexes, sort then add index?
Thanks