CC_Mu Posted May 1, 2018 Share Posted May 1, 2018 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!! Link to comment Share on other sites More sharing options...
Juvigy Posted May 2, 2018 Share Posted May 2, 2018 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. water 1 Link to comment Share on other sites More sharing options...
Moderators JLogan3o13 Posted May 2, 2018 Moderators Share Posted May 2, 2018 @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! Link to comment Share on other sites More sharing options...
CC_Mu Posted May 7, 2018 Author Share Posted May 7, 2018 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 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now