Hi,
I'm currently doing a lot of re-arrangements for columns in Excel. It has to be in a particular order before I send it for processing and the arrangement of the column are in another spreadsheet with the exact name.
Is there any way to re-arrange them automatically using macros?
For example:
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Last name[/TD]
[TD]Age[/TD]
[TD]First name[/TD]
[TD]ID number[/TD]
[TD]Location[/TD]
[TD]Date[/TD]
[/TR]
</tbody>[/TABLE]
Re-arranged into:
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]First name[/TD]
[TD]Last name[/TD]
[TD]Age[/TD]
[TD]ID[/TD]
[TD]Date[/TD]
[TD]Location[/TD]
[/TR]
</tbody>[/TABLE]
Thank you for taking your time to read!
I'm currently doing a lot of re-arrangements for columns in Excel. It has to be in a particular order before I send it for processing and the arrangement of the column are in another spreadsheet with the exact name.
Is there any way to re-arrange them automatically using macros?
For example:
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Last name[/TD]
[TD]Age[/TD]
[TD]First name[/TD]
[TD]ID number[/TD]
[TD]Location[/TD]
[TD]Date[/TD]
[/TR]
</tbody>[/TABLE]
Re-arranged into:
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]First name[/TD]
[TD]Last name[/TD]
[TD]Age[/TD]
[TD]ID[/TD]
[TD]Date[/TD]
[TD]Location[/TD]
[/TR]
</tbody>[/TABLE]
Thank you for taking your time to read!