Hello all,
Just need a little help writing a macro that will rearrange columns in a worksheet based on the header.
Currently, my worksheets have up to 10 different unique column headers that need to be in a specific order (after running the macro).
However, the worksheets may not always contain all 10 unique headers, sometimes only 6 or 8. If this is the case, the macro should simply place the columns in order (skipping over those columns missing).
For example:
DFACBE becomes: ABCDEF
DFABE becomes: ABDEF
If columns need to be placed in a specific column, maybe a separate function that will delete empty columns if needed.
Any help would be most appreciated – thanks!
Bookmarks