VBA Code for Sorting Values inside Cell for two columns
Hello,
I need to sort values given in attachment sample sheet. Values will be in G and H columns. For sample purpose only two Sr No are taken but in actual number of data may extend upto 50 Sr No.. Also code should not affect values in other cells. Also please explain where ranges can be changed if i change position of the values in example.
Thank you.
You need to show not only what you have, but what you want based on the examples that you show.
Bernie Deitrick
Excel MVP 2000-2010
Hello,
Thanks for reply,
I have attached two files. one is showing data before execution of code. Data in that file is in original nature.
But when code executes it will sort values in that cell only in ascending order. It will not create new sheet or new file, instead of that it will sort data in the same cell of that file.
In second attached file result after code execution is shown.
Select the cells that you want to have sorted, then run this code.
Please Login or Register to view this content.
Truly very thankful to you. Its working smoothly. Thanks a lot.
I know this is solved...But I notice that above code sorts
10.10.100.110.12.150.2.20.200.225.4.4.5.5.52.6.8.8
Should it not be...As per your result file attached...
2.4.4.5.5.6.8.8.10.10.12.20.52.100.110.150.200.225
Just for future reference...Another Option...
If it should be as per first result in red then with below code...remove
If it should be as second result, then leave below code as is...Please Login or Register to view this content.
to edit Bernie code for 2nd sort...Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by sintek; 03-19-2022 at 03:10 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Grateful to you. Thanks for your keen observation which got skipped in hurry. Code is working fine. Thanks again.Adding reputation
..........................
Thanks.png
It's odd - my code worked perfectly on the example workbook, so I'm not sure why it gave you the results it did.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks