Rearrange column with fixed headers

[Shermaine2010]

Raw tab is raw data generated from system. Every time I need to manually copy and paste to remove the columns become result tab header.

How to write VBA code to skip the manual workaround?

Help.

[AlphaFrog]

Record a macro where you move\copy\delete your columns.

[mike7952]

Heres one way using a User Defined Type array. Maybe over kill but easy to read and if you decide to Rearrange the output in the future will be easy to update.

Please Login or Register  to view this content.

[Shermaine2010]

Record a macro where you move\copy\delete your columns.

The columns will be changed once I moved to back.
Example： Allowance Code is column I. After moved it next to name, Allowance Code at column C. The rest of column will changes. Continues, the rest of column will keep changing once I move one fields.
I can't fix the column B:B or C:C into VBA code.

[Richard Buttrey]

If I understand the requirement then isn't a simple advanced filter the obvious choice.

i.e.

Please Login or Register  to view this content.

[AlphaFrog]

The columns will be changed once I moved to back.
Example： Allowance Code is column I. After moved it next to name, Allowance Code at column C. The rest of column will changes. Continues, the rest of column will keep changing once I move one fields.
I can't fix the column B:B or C:C into VBA code.

Yes you can. Give it a try. It's easy to test.

[AlphaFrog]

The columns will be changed once I moved to back.
Example： Allowance Code is column I. After moved it next to name, Allowance Code at column C. The rest of column will changes. Continues, the rest of column will keep changing once I move one fields.
I can't fix the column B:B or C:C into VBA code.

Yes you can. Give it a try. It's easy to test.

[Shermaine2010]

Yes you can. Give it a try. It's easy to test.

Yes. I got it with the code provided by you. Thanks