Thanks Mr. Excel, this worked great, much better than the 4 individual macro's that i'd struggled over using 1 for each sheet. How do I add that i need 1 column filtered for no blanks?
this worked great, just what i asked for, but i see now that i need 2 criteria. field 11 = blank AND field 10 not equal "AR" but the AR is not text, it's in a number field. I spent about an hour playing and researching and can't find how to do this, can you help?
Dang, I was hoping it would help me out but I have a very large spreadsheet I use and need to sort using at least 5 columns. Do you know of a simple solution for that? Thank you.
Hi, is there anyway i can sort it according to my liking? like, i may not want it to be in ascending or descending order. for example, i want it to sort in this order (eggs, books, cups) instead of (books, cups, eggs)
No i dont use mac. and i already tried recording marco for sorting and its sorting also by color but entire data is not changing along with it. it sorts only particular column
I liked the way you explained your code word by word, it gave me a better understanding than some of your other videos.
Fantastic - this is so much more simple it's memorable!
Hey Bill, great video as always. Thank you.
Wow!! Gobsmackingly easy. I was using the macro recorder with limited success. Thanks for a great video and your easy, laidback style of explaining.
GREAT video! Really useful warning that a blank row is needed above the table. Thank you!
Thanks Mr. Excel. Love the vba videos.
Excellent, I have been looking for a sort solution for a long time!!
This was awesome trick for sorting. Thanks Bill.
Cheers Bill, I'd forgotten this GEM! Saved my bacon mate!
Very nice. Converted 7 lines of code to 1. :)
I want the Polish VBA Book!!! : )
can you make sorting rows ascending order for 500 rows? Thanks
Milk, Eggs and Vodka? Haha, Bill, you're fantastic!! That video helped me a lot! Amazing thing :-) Thank you so much and greetings from Switzerland
Thanks Mr. Excel, this worked great, much better than the 4 individual macro's that i'd struggled over using 1 for each sheet. How do I add that i need 1 column filtered for no blanks?
Thanks Mr. Excel, I'll work on this right away.
this worked great, just what i asked for, but i see now that i need 2 criteria. field 11 = blank AND field 10 not equal "AR" but the AR is not text, it's in a number field. I spent about an hour playing and researching and can't find how to do this, can you help?
Perfect, thanks Mr. Excel. I was dancing around that for an hour and I still don't know why mine was wrong, but yours is always right ! Thanks again.
Sir, if I sort 2 columns from table the other columns also sorting. How to stop dis?
Dang, I was hoping it would help me out but I have a very large spreadsheet I use and need to sort using at least 5 columns. Do you know of a simple solution for that? Thank you.
How I can sort 4 columns or more?
Great Video thanks
Does this work with more then 3 column sorting ?
Bill, my files comes out in the morning as .xlsx files. Any way to use on non .xlsm file files? Thanks
Great video! I have some questions:
The [key n] argument, does it have to be a column or a single cell?
how do you sort in custom orders?
Hi, is there anyway i can sort it according to my liking? like, i may not want it to be in ascending or descending order. for example, i want it to sort in this order (eggs, books, cups) instead of (books, cups, eggs)
Check out custom lists: ruclips.net/video/3f53TKogaAY/видео.html
Hey Bill Liked your videos, i just wanted to know how we can sort data by cell color
No i dont use mac. and i already tried recording marco for sorting and its sorting also by color but entire data is not changing along with it. it sorts only particular column
Hi Mr Excel, Do you have tutorial on how to search or find from cell data to multiple text file?
I don't have any tutorials on this, but check out Notepad++. It is a free text editor that has the ability to Find & Replace all files in a folder.
What a massive soting solution..!!
very good!
What about sorting on two columns?
Thanks, I never could get it to work!
fantastic!
Thank you
شكرا لك