Hello everybody
I have in the attachment some columns which are different in height
I want to reorder the columns by code and get the results in another sheet
The desired results are illustrated in Sheet2
Hello everybody
I have in the attachment some columns which are different in height
I want to reorder the columns by code and get the results in another sheet
The desired results are illustrated in Sheet2
Not sure if you need VBA for it. But you can insert a help row to count the total records, then go to Sort > Option > Sort by Rows
Thank you very much Mr. JieJenn
I know that way ..But I need to do it by VBA
Try this
![]()
Please Login or Register to view this content.
Mr. jindon .. Really wonderful
I can't express ny happiness with this awesome code.
Just a little point
I don't know how to get my results in sheet2
Hi,
An alternative :
Regards![]()
Please Login or Register to view this content.
Forum rules : http://www.excelforum.com/forum-rule...rum-rules.html
Change
to![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Thanks a lot Mr. Jindon for this great help
Mr. karedog I tested your code but got 1004 error at this line
![]()
Please Login or Register to view this content.
Sorry, previous code is for the range start on row 2 downward.
Here is the new code :
Regards![]()
Please Login or Register to view this content.
Thank you very much for all of you everybody
You are welcome, glad I can help.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks