Need Excel macro to check order of columns ?

As an part of QA activity
1. first I export data and directly paste in the "RAWDATA" Sheet.
2.There are 50 columns and each has header like Clientname,date,Id,campaign,websitename,frequecncy etc.
3.Exported data does not have same order
4.so when I paste data in excel I check manually if orders are in correct or not?which takes my long time to review/manually check

so can anyone help me in excel using macro or something else to review the order and if any discrepancy then raise error? Need Excel to check order of columns ?

Since Excel can sort from left to right I would suggest you make a "custom list" containing all the headers and the order you wish them sorted in and use this list to sort your columns in the proper order.

Alf