CC_Mu Posted May 1, 2018 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!!
Juvigy Posted May 2, 2018 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
Moderators JLogan3o13 Posted May 2, 2018 Moderators 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!
CC_Mu Posted May 7, 2018 Author 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
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