Hi,
I'm having difficulty with a macro. I'm trying to re-order the columns in a tab based on a specified order. For example the top row has "x" in column A (cell a1), z in column B (cell b1), y in column C (cell c1), w in column D (cell d1). Could you please help me figure out the macro required to re-arrange the entire columns so that the order of the top row was "w,x,y,z"?
I've attached the worksheet which shows the original state.
Bookmarks