Hi,

I have attached a sample file example.xlsx - Sheet "Initial" contains the column headers in the order that is being exported, and Sheet "Final" contains the columns in the order I need. I have highlighted the columns that are being moved.

I need the macro to rearrange the columns based on column header and not based on column labels, because the order in the file exported (Initial) is changing constantly and this would require updating the macro with the new column labels very often.


Hope you can help.
Thank you very much,
Iulia