moving columns around?

[etsoft]

Hi,

i've got a table in excel where some of the columns headers have numbers , f.i. 20131 and 201212 ( year + month ), i want move these colums around so that 201212 come earlier or more to the left then 20131.
I can change the labels of the columns if needed.

Can this be done via vba?

The data comes from access and i have no way to alter the sequence there.

Regards
Erwin

 

[AlphaFrog]

Hi,

i've got a table in excel where some of the columns headers have numbers , f.i. 20131 and 201212 ( year + month ), i want move these colums around so that 201212 come earlier or more to the left then 20131.
I can change the labels of the columns if needed.

Can this be done via vba?

The data comes from access and i have no way to alter the sequence there.

Regards
Erwin

Can you change the labels so that the numbers are all 6 digits yyyymm; 201212, 201301 ? If yes, you could then select your numbered columns and select from the menu Data\Sort. It has an option to Sort Left to Right.This can be recorded to a macro.

 

[etsoft]

Can you change the labels so that the numbers are all 6 digits yyyymm; 201212, 201301 ? If yes, you could then select your numbered columns and select from the menu Data\Sort. It has an option to Sort Left to Right.This can be recorded to a macro.

Yes, thats it! Many thanks.

 

[AlphaFrog]

You're welcome and welcome to the forum.