Jump to content
Sign in to follow this  
CC_Mu

How to re-order excel column

Recommended Posts

Hey guys,

 

I have an excel worksheet with 50 columns, 2000 rows, how I can re-arrange them by column name? 

e.g. current column a,b,c

--> desired column a,c,b

 

how I can do it? Thank you so much!!

Share this post


Link to post
Share on other sites

Use excel and record a macro of what you want to do. Then use Excel UDF and convert the macro to Autoit. It is very easy.

Share this post


Link to post
Share on other sites

@CC_Mu when you say "by name" are we to assume you have a column header? Or are you actually going to use the Column Letter (A1) format?


"Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball

How to get your question answered on this forum!

Share this post


Link to post
Share on other sites
On 5/2/2018 at 6:59 AM, JLogan3o13 said:

@CC_Mu when you say "by name" are we to assume you have a column header? Or are you actually going to use the Column Letter (A1) format?

I have a column header, like company, name, id, date etc

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...