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 :
RegardsPlease Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
Change
toPlease 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 :
RegardsPlease 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