How could I rearrange the columns by the columns header name.
I need to process a report on weekly basis,the raw worksheet has 23 columns.I abstract a part of them as example.
Raw columns sequence:
<tbody>
</tbody>
Desired columns sequence:
<tbody>
</tbody>
Any idea how to automatize the columns rearrangement with VBA code?
Many thanks in advance.
I need to process a report on weekly basis,the raw worksheet has 23 columns.I abstract a part of them as example.
Raw columns sequence:
QTY | Payment Terms | Contract No. |
<tbody>
</tbody>
Desired columns sequence:
Contract No. | Payment terms | QTY |
<tbody>
</tbody>
Any idea how to automatize the columns rearrangement with VBA code?
Many thanks in advance.