If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what topics you want me to cover in future videos.

@gsssbibipurschoolpatiala6416

4 жыл бұрын

ÁWESOME VIDEOS Dear Sumit sir, sir ,,, I means macros which single click to convert Excel to PDF useful for all worksheets of workbook that encompass FIT all Columns on A4 Page and convert Excel to PDF ... Thanks Again for sharing great stuff. HATS OFF handy macro pops up dialog box and message FIT ALL COLUMNS in A4 and then convert excel to pdf ...

@laxmangiri7204

4 жыл бұрын

Happy to see you here in KZread

@abdulrahmanbaamer8624

4 жыл бұрын

Great video. How to do the same in power query (not required to be dynamic), but search string in another query and return all "search" results. Thanks in advance.

@sadeqs7680

4 жыл бұрын

Thanks for your nice videos 👍 There's a little problem, this VBA does not work with numbers! I mean it doesn't filter numbers.

@tanishkastationary

4 жыл бұрын

Can I dynamic filter works on multiple data in a one cell ??? Plz reply

I can´t believe that after watching multiple videos and not being able to do it, you just gave a perfect explanation, you are the man! Thank you for sharing.

@trumpexcel

Жыл бұрын

Glad the video helped 😊

I'll repeat what so many have said in the comments, after looking at multiple videos, yours is by far the clearest, most concise "step by step" on KZread. Others seem to jump steps to shorten the tutorial others seem to complicate their formulas to achieve the exact same result...You my friend, are a gem!

@trumpexcel

Жыл бұрын

Thank you for the kind words. I am glad the video has been useful 🙂

Like the way you are walking us through tips with examples. Highly useful. Thank you.

This is the only VBA code that has worked for my version of Excel so far - thank you!

Simple, yet powerful! Thank you, boss.

Your videos are great. They are short and to the point and they are always relevant.

Great video, I am so glad you consider those of us that do not have the insider 365 version.

@trumpexcel

4 жыл бұрын

Thanks for commenting Rick... Glad you found the video useful!

This is the most effective application oriented code. It shows ur genius towards making the code application specific

Thank you professor. Finally I found my wish tutorial clip. I tried so hard to find how to create serch box as filter+drop down ^_^

After living many years with a dynamic filter that always gave an error, I was unhappy and kept looking for a solution, as many have said I watched many videos and none brought the solution so accurately, you deserve many likes👏👏

Thank you so much for this video/ I spent hours looking through others which were of little to no help. Your video was clear to understand and so helpful

Thank you so much, dear teacher, for this great video and for this explanation the best.

What a nice straightforward way.

Absolutely brilliant, keep up the good work. Best wishes

Love your videos you make everything look so easy thank you!

Good one and very well explained, as usual!

Great as always, thank you Sumit.

Excelent video, this is what i've looking for so long. it is a very useful tool. Thank you So much !!

Nice tutorial, just I was looking for. Well done.

Thank you, really appreciate the detailed explanation.

I've been trying to do this but didn't know what it was called! Ahhhh thank you!!!

thank you. you earned another sub for being straight to the point.

This is a great trick with FILTER : ) : ) Thanks for the Totally Awesome Video, Sumit!!!!

@trumpexcel

4 жыл бұрын

Thanks for commenting Mike... Glad you liked it!

@excelisfun

4 жыл бұрын

@@trumpexcel Go Team!!!!!!

@sandeepnair8226

2 жыл бұрын

@@trumpexcel Sir what if one name falls in 2 or more regions. like if Rob falls in US, Cananda & Asia at a time? How would be the syntax Sir? Thankyou

@sandeepnair8226

2 жыл бұрын

@@excelisfun Sir what if one name falls in 2 or more regions. like if Rob falls in US, Cananda & Asia at a time? How would be the syntax Sir? Thankyou

thanks sumit as always simple and helpful

Thank you very much Sir, for sharing such valuable and useful knowledge.

A very useful and nice tutorial. Thanks a lot. 👍 🌟 🌟

Very well explained, Thank you

Thank you for this great class!

@trumpexcel

4 жыл бұрын

Glad you found it useful George!

Ur channel is good enough, no need of searching anywhere for the excel related information👍😎

@trumpexcel

3 жыл бұрын

Thanks for the kind words Arun... Glad you're finding the videos useful!

You are awesome Sumit. Thanks for the Tip

This is GREAT! Thank you!

very very helpful video. Thanks for sharing

Gazab...... Very nice & useful technique. You r great.

This man saved my ass at work today 🙏

Speechlees, you are just amazing

Really really helpful !! Thanks a lot !

You are one of the best. Keep up the good work.

Nicely done Sumit. Thanks.

Good one and very well explained.. 👍🏻

Brilliant. Thank you

Great Stuff!! Very nicely explained

thank you it's really helpful.

Amazing video 📹 thank u for ur hard work Mr. Trump Excel :)

Thank you so much for this!! :)

Thank you for this tutorial it is exactly what I was looking for. How do i then add the search value to the table if value is not found without having to scroll down to the bottom of the table as you may have 500+ entries?

Very useful, thanks!

First time on your channel. This was interesting!!! : )

Thanks😇😇😇 from the bottom of my heart.

important tip, thank you so much!

Wow, incredible!!!!!!!!!!! Thx a lot

Fantabulous. Hats off to boss..

A big thumbs up... Thanks a lot..

Thank you sir, this was needed to me badly thanks once again

Excellent very nice video Sir Thanks a lot🙏🙏

👍Good one, will try...

Amazing THANK YOU

Very useful video Thank you very much sir

Super video brother.. resolved my problem. Awesome

Great job, excellent

very excellent function

Good informative video sir, thank you so much

Always useful stuff on your channel:-)

very useful video .. really helped ..

You are awesome. Thank you

Very helpful!

It's very helpful thanks

@trumpexcel

4 жыл бұрын

Glad you found it useful!

Thank you very much 🥰

This was excellent... 👍

Really you are great....

Amazing thank you

Thanks for this video! This is wonderful, however how do I apply the filter across an entire table vs a single column?

Hi ,,, very nice explanation and useful

Wonderful thank you

thanks for Filter rhtough Vba Code in excel because i was also finding Ulternate of Filter Function.

Thank u Perfect !!!!

Great video

Thank You so much for the tutorial. Can you please provide a way to extract specific rows dynamically on another sheet that meeting a criteria.

very nice thank you

Thank you soooo much sir⭐⭐⭐⭐⭐

खतरनाक 🙏

Great video 👍

Excellent 👌

Very informative

Man, you are a genius! Thank you a lot! I've subscribed and liked it! And please can you help how can I filter in several fields?

Thank you very match

Thank 😊 so much 💖

THANKS A TON!

Thanks a ton!

thank you so much

Your content is God level Sumit, learners like us needs professors like you to learn advanced level of Excel. I was just wondering if you have any plans to cover Power BI in future???

Great show very nice and thank you for the code. I use this code for my schoo to search students by searching of id and make another setch box for servhing by students name and it is very nice

Hi Sumit Really what I was looking for. Thanks a lot !! Additionally, is it possible to add a second filter for another column, and display results based upon the output after 2 filters ?

Excellent

THANKYOU SIR

Genius!

Awesome!!!

Well done

GOOD VIDEOS!

Amazing. This is what im looking for. No vba.