Thanks Rick! I always wanted to build a macro, but hated the idea of reading the instructions. Then I realized there might be a macro instructions on specific macro I was looking for, and this was it. Man! easy to follow and spent 20 minutes building your macro on my spreadsheet that I could use. Great JOB!!
I've found this video really helpful in sorting a long list. A couple of things not mentioned in the video that I also found helpful. 1) If you use asterisks around your search string ("*Packard*") , you will get find items that match anywhere in the respective cell (e.g. "Hewlett Packard" would match) 2) For large lists, the method in the video for resetting the filter can be slow (for me it took ~5 seconds). A faster way to reset is to record the macro using the Data Tab, and then selecting - "Clear" from the Sort and Filter section, instead of deleting the criterion cells and running the Filter macro again.
im just starting and tNice tutorials video was perfect.Well explained and easy to follow for a beginner.I never understood soft soft till i watched tNice tutorials.
Wow this video is Amazing!! I do have some trouble with the “reset” filter button. Whenever I click to reset, it freezes my sheet and takes over a minute to clear. Any information on how to fix this it would be a life saver. Filter works Excellent.
Hi Rick, Very well explained, Just need understanding how we can filter dates. I want to filter through dates but Its not working may be some date format issue. Can you please help me out.? Thanks
thanks however too many times macros were set and so found it confusing, can u make same video with less setups and crisp so begginer would understand.
Is it possible to let the data list auto extend by time to time without re-recording Macro? I mean my data list updated daily and getting more rows. I want to create the button for that data list. Thanks a lot.
Sir, I have about 8000 odd records in my table. When I reset the filter, it takes something like 2 minutes for the excel sheet to respond. Could you help me with that?
This was very helpful but I am having an issue now. I had to add some headers and was able to everything to expand to the new ones with the exception of List. I keep defaulting back to the original selection. Help!
Deidra, you may have to either edit or delete and recreate your list range. Click "formulas" and then "name manager." From there you should be able to change or replace your list range. Also check your criteria range while you are in the name manager to make sure that it contains the correct columns.
If you go to formulas > Name Manager, you can delete your list range and then re-create it - or you can use the name manager to edit the list range. Hope that helps
Thank you for the video ! I have a question - If you search Biomet or Mobile will it show you the results ? Or you need to put it a word or alphabet with which the name starts ?
you could create another macro that copies your data into the criteria selection fields. Make sure that you use paste > values so that you don't put the formulas into the criteria.
Thanks Very Much Rick for the tutorial, But i'm stuck at one point where i have to select multiple values in a single column. Any help is very much appreciated.
You will need a two-row criteria range to select two different values. The second row will be 'or' ed with the first. I will work on a video that explains this and creates a macro that automatically determines which range to use. RK
All, this channel was never intended to be maintained. It has been replaced by my new channel: th-cam.com/users/koontzrd. The above video can be found at th-cam.com/video/YwH1yJEu0EQ/w-d-xo.html Thanks.
Did nobody else hear the screaming in the back? Sounded like a possessed young child!? I mean the vid helped....thanks. That was scary though. Please tell me your not holding kids.
It actually sounded more like a bunch of children playing in a wide open indoor area that echoes, such as a gym. But yeah, the video was really useful.
Excellent!! But My Data has some 800 records and excel is taking very long time(sometmes becomes unresponsive) when i reset data. Can you help me with that?
Thank u sir... I have seen many videos bt didn't get a satisfy result.. Ur vdo is awesome.. I need this..for my project. Can I have Ur Skype id.. for future contact. In excel problem..??
Kyle, Sorry about the screaming in the background - My office is in a building that includes a gymnasium and the volleyball team must have been practicing... Looks like I will have to re-record now that their season is over...
The one tNice tutorialng I would like to do (and tNice tutorials will completely convert ) is to copy and paste items from one project to another, it just doesn't
Thanks Rick! I always wanted to build a macro, but hated the idea of reading the instructions. Then I realized there might be a macro instructions on specific macro I was looking for, and this was it. Man! easy to follow and spent 20 minutes building your macro on my spreadsheet that I could use.
Great JOB!!
I've found this video really helpful in sorting a long list. A couple of things not mentioned in the video that I also found helpful. 1) If you use asterisks around your search string ("*Packard*") , you will get find items that match anywhere in the respective cell (e.g. "Hewlett Packard" would match) 2) For large lists, the method in the video for resetting the filter can be slow (for me it took ~5 seconds). A faster way to reset is to record the macro using the Data Tab, and then selecting - "Clear" from the Sort and Filter section, instead of deleting the criterion cells and running the Filter macro again.
im just starting and tNice tutorials video was perfect.Well explained and easy to follow for a beginner.I never understood soft soft till i watched tNice tutorials.
A big 'Thank You" for such an easy to follow video. The dread factor of using Excel was nullified.
This tutorial was GREAT!!! Thank you. I was able to replicate it to many of my lists and they worked! Very GRATEFUL!!
Yes, just echoing all the other comments - a great video, so well explained and easy to follow. Many thanks!
This was amazig!!! Thank you, I was looking for this and you couldn't explain it any better!!!!
@Mark Wadsworth . beef FCU. Qqza
you are a great instructor. a very well designed and thought tutorial.
You took the words right outta my mouth.
this video is the most helpful one i have seen in this subject why you stopped making new videos in your channel ?
No idea I could do this!!!! It’s wonderful thank you so much!!!
Thank you, it really works and very minutely explained. Thank you again
Nice tutorial. I have been having content issues with my hmdi connected speaker and subwoofer. No soft is coming through, still coming out of
Very simple and precise, thanks Rick!
Thank you Sir! Very informative and easy to follow. GodBless.
th-cam.com/video/QkHPgbGEdzU/w-d-xo.html you can watch my excel training videos...
Wow this video is Amazing!!
I do have some trouble with the “reset” filter button. Whenever I click to reset, it freezes my sheet and takes over a minute to clear. Any information on how to fix this it would be a life saver.
Filter works Excellent.
Riyen Ayala me too
thanks bro regards from Syria
TNice tutorials person speaks the truth, the whole truth and notNice tutorialng but the truth
Hi Rick, Very well explained, Just need understanding how we can filter dates. I want to filter through dates but Its not working may be some date format issue. Can you please help me out.?
Thanks
thanks however too many times macros were set and so found it confusing, can u make same video with less setups and crisp so begginer would understand.
Great video. Thanks for your help Rick!
nice and neat video, to the points and easy to understanding!
Is it possible to let the data list auto extend by time to time without re-recording Macro? I mean my data list updated daily and getting more rows. I want to create the button for that data list. Thanks a lot.
Its very helpful to me thanks.....
Thank You Mr. Koontz simple explained
impressive,very well said,tNice tutorials is what I need to learn soft soft,your the bes n
I got the tutorial very helpful; thank you!!
Thank you so much. This really helps a lot. Kudos
Hey Rick, Thanks for the video. I was watching it for a minute, and thought it sounded like you.
Just saw your comment, - you are correct :)
I’ve been searching for ages on how to do this and finally this is a straightforward tutorial to follow, thanks.
Can I import my softs into soft soft and process without using a mic
Great Video this will definitely help me at work
Thank you! It helped a lot.
You are awesome brother, thanks a ton for this :)
I found out why soft softs so different compared to Ableton. It is because there is a default limiter on the master that i didn't know about.
Thank you rick, this video is helping me, but how we filter numeric data?
Sir, I have about 8000 odd records in my table. When I reset the filter, it takes something like 2 minutes for the excel sheet to respond. Could you help me with that?
Hi, A quick question can I copy headings to the right instead of above so I have my search on the right?
This was very helpful but I am having an issue now. I had to add some headers and was able to everything to expand to the new ones with the exception of List. I keep defaulting back to the original selection. Help!
Deidra, you may have to either edit or delete and recreate your list range. Click "formulas" and then "name manager." From there you should be able to change or replace your list range. Also check your criteria range while you are in the name manager to make sure that it contains the correct columns.
If you go to formulas > Name Manager, you can delete your list range and then re-create it - or you can use the name manager to edit the list range. Hope that helps
I am using Excel 2019 and somehow this is not working for me. Is it possible to share this template with us?
Thank you for the video ! I have a question - If you search Biomet or Mobile will it show you the results ? Or you need to put it a word or alphabet with which the name starts ?
It's useful & thanks you very much indeed. But If I have a lot data , it's loading for so long. Can I have any advise how to process on it. Pls!!!
Social Justice Warrior O had the sa problem. click GMS and inside the Program push app and Analog 1 TE. Hope tNice tutorials helps ✌
good one, but instead of static data I.want to use dynamic date.
can I use offset formulae in criteria range? Or is there any other way
you could create another macro that copies your data into the criteria selection fields. Make sure that you use paste > values so that you don't put the formulas into the criteria.
Superb thanks so much
Thanks Very Much Rick for the tutorial, But i'm stuck at one point where i have to select multiple values in a single column. Any help is very much appreciated.
You will need a two-row criteria range to select two different values. The second row will be 'or' ed with the first. I will work on a video that explains this and creates a macro that automatically determines which range to use.
RK
Thanks RK ! I believe your video will be a complete reference if you do that :)
party samples/generators/etc. you use are.
other desktop soft making software have more features and you can do much more than you can on mobile but the user interface in
how would you filter lesser, equal, or greater than? EXAMPLE, want to filter anything over $1,000.00 ?
All, this channel was never intended to be maintained. It has been replaced by my new channel: th-cam.com/users/koontzrd. The above video can be found at th-cam.com/video/YwH1yJEu0EQ/w-d-xo.html Thanks.
When I apply the format of the table is gone why is that?
Thank You Very Much
Awesome, thanks!
Does anyone has a working template to share with me please? Somehow I am having no luck in making this work on my tables. Thank you
good topic but is there a clearer video?
its great!
how can search with multiple partial string in criteria?
th-cam.com/video/QkHPgbGEdzU/w-d-xo.html you can watch my excel training videos...
thank you learned a lot!
we need àdvanced vba book can u give address
I'm in quarintine (like everyone) and wanted to learn sotNice tutorialng new. I thought I could just figure it out but soft is super confusing for a
I also really appreciate if the author make a video about UnsetupIt, an app that can isolate or remove softs from a . TNice tutorials app is really
can i do tNice tutorials with the trial version?
how to use SQL in excel ...
I want to use group by and order by . plz help
th-cam.com/video/QkHPgbGEdzU/w-d-xo.html you can watch my excel training videos...
Is that correct or no?
Did nobody else hear the screaming in the back? Sounded like a possessed young child!? I mean the vid helped....thanks. That was scary though. Please tell me your not holding kids.
It actually sounded more like a bunch of children playing in a wide open indoor area that echoes, such as a gym. But yeah, the video was really useful.
Guys what computer should i use?
Excellent!! But My Data has some 800 records and excel is taking very long time(sometmes becomes unresponsive) when i reset data. Can you help me with that?
yes, when you get lots of records, the reset can be slow. You can try clicking clear under data > sort & filter.
Thank you
Thank you!
th-cam.com/video/QkHPgbGEdzU/w-d-xo.html you can watch my excel training videos...
like tNice tutorials are genuinely ant, it helps make the world a better place. Thank you for the amount you wrote too, I can tell you sincerely care.
I have loved soft all my life but felt trapped and muted by the fact that I couldn't create my own. Over the last or so years I've tried
Thanks sir
I Love you Very Much
I think hlookup function is better than advance filter by filtering the data
Wawooo nice video
└⚠️ TNice tutorials folder is empty
Thank u sir... I have seen many videos bt didn't get a satisfy result.. Ur vdo is awesome..
I need this..for my project.
Can I have Ur Skype id.. for future contact. In excel problem..??
program.
U can filters to it and be done with it lol
TNice tutorials is not what i see when I open soft soft at all.
LMFAO
lol
but I guess I just have to deal with bluetooth, tNice tutorials is a big con.
Kyle, Sorry about the screaming in the background - My office is in a building that includes a gymnasium and the volleyball team must have been practicing... Looks like I will have to re-record now that their season is over...
lol
i'm gonna rena and change color on my channel to stay super organized
wondering if u would be willing to collab to make a . TNice tutorials would be my first and I would understand and apprehensions you may
The one tNice tutorialng I would like to do (and tNice tutorials will completely convert ) is to copy and paste items from one project to another, it just doesn't
I am coming from soft one 4.6 and I am so torn with soft soft. It seems great as it is so in-depth in its' capabilities but, so fiddly to get
Nice tutorial, could you please teach how to remove softs from a ? for karaoke purposes. Than you
Nice tutorial, I have a problem wNice tutorialle using soft soft .
Well to be fair shape of you lody softs just like the first random notes that popped into Nice tutorials head
This is exactly what I was looking for! Tremendous help man! Really good!
Thank you so much..so informative and helpful..
I already made a soft in like 3 hours its that hard
amazing tutorial , thank u very much
so much. Can’t wait to start making soft.
i need an soft soft crack how can i get it
Hands down tNice tutorials is one of the best tutorials I've seen on any subject, ever! Clear, concise and incredibly informative and easy to follow.
So I went into soft soft and tried to intuitively grasp the basic fundantals. And now listening back I feel like I'm one step ahead of Nice tutorialm.
Can I apply this in table
AWESOME VIDEO ... I hope U only can help me on this , I am trying more than 2 mouth not able to do this, can you please help me