I have a set of data that comes out of a program in excel format that contains a table of data. If there is no data for a given row/column it is not brought down to excel. Furhtermore the output is not in the order I need.
I need a macro that will re-sort the data in the rows and columns based on an ordered array, even if there is no data found for the array item (essentialy leaving a blank line where it would have been).
Any guidance is appreciated.
I need a macro that will re-sort the data in the rows and columns based on an ordered array, even if there is no data found for the array item (essentialy leaving a blank line where it would have been).
Any guidance is appreciated.
