Master These Simple Filtering Hacks In Excel VBA Today
Vložit
- čas přidán 2. 08. 2024
- 🔥 GET THIS + 350 OF MY BEST DONE-FOR-YOU TEMPLATES HERE ► rebrand.ly/350Wkbks_YTDesc
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
🤖BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ► rebrand.ly/AIToolpack_YTDesc
👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ► rebrand.ly/MentorshipProgram_...
▶️ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
👨💼BECOME AN EXPERT AT DASHBOARDS ► rebrand.ly/ExcelDashboard_YTDesc
📣START LEARNING VBA HERE ► rebrand.ly/VBAEFFDan_YTDesc
🏝BECOME A SUCCESSFUL FREELANCER ► rebrand.ly/FreelancersAcademy...
⭐️JOIN CZcams MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this training, I will show you how to become a master at filtering with Excel VBA. We start from the simple basic filter and move up to advanced filters and include every possibility so that you can master filtering in no time at all.
⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
bit.ly/FilterFundamentals_WkbkDl
🤑 START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM 👉 rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
►FREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
►MENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
►DASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
►BEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
►WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
►Turbocharge Your App Development: rebrand.ly/UDVL_YTDesc
►Get 350 Templates In 1 Zip File: rebrand.ly/350Wkbks_YTDesc
►Get ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
►The Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
►Get Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
►1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
Timestamps:
0:00 - Introduction
1:51 - Basic Filter
3:31 - Clear Filter
3:54 - Filter Numbers
4:47 - Filter Dates
8:18 - Advanced Filter
22:12 - Overview
JOIN OUR COMMUNITY:
►Facebook Group: rebrand.ly/EFF_Group
►Facebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
🤩TikTok: / excel4freelancers
🐦Twitter: / excel4freelance
🌏Website: www.ExcelForFreelancers.com
🔗LinkedIn: / excelforfreelancers
👤Facebook: / excelforfreelancers
📸 Instagram: / excelforfreelancers
🎥Rumble: rumble.com/c/ExcelForFreelancers
✉Telegram: t.me/ExcelForFreelancers
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
👉 / excelforfreelancers
New Training Video Uploaded every Tuesday!
Thank you very much for your continued support,
Randy Austin
#ExcelForFreelancers #filters #advancedfilters #vbafilters #filterInExcel
🔥Boost Productivity with 350 Customizable Workbooks ► rebrand.ly/350Wkbks_YTPinnedCom
Once again Randy, thank you so much for this weekly VBA training. I wish you a Happy and Excellent New Year.
For sure, you are very welcome Carlos, and Happy New Year you to you and your family as well
for ever you are the best in excel , this my opinion
Thank you so very much, I really appreciate that
Thank you Randy for doing these basic training.
I really hope you could do a
1. do while loop
2. Find and find next aldo with multiple columns
Hope you could help
Hi and thanks. Yes for sure I will be doing these in the Basic VBA Series. (You had requested the Find and find next with multiple criteria before and i have already written it down in my notes)
Thanks so much for your suggestions.
Happy New Year Randy THNX For Sharing
For sure, you are very welcome Henk and Happy New Year to you and your family. Thank you for your Likes, Shares & Comments. It really helps.
Thank you Randy for this amazing video.
For sure, you are very welcome and I am happy to help adn share :)
I appreciate that, thank you and waiting to have new best videos like these.....
For sure, you are very welcome and thanks so much. Yes every Saturday is a new training for VBA Beginners. I hope this helps and thanks so much.
Thanks a lot we need this type of videos, all that matters with vba
Great and thanks so much Khalid. I am happy to help and share
Hi Randy thanks for sharing
For sure, you are very welcome Tobaye, and thanks for your continued support over many years. Happy New Year
Hi Randy! First of all thank you very much for all your videos on VBA. I have learnt so much and really appreciate your channel. With regards to this video, I managed to recreate every filter and got them to work, apart from one. The date Filter. For some reason, the filter (when applied) removed all my dates in the column and left no lines. I checked everything close to a thousand times and after trying a few different options to filter between, I realised something... I have my PC set to UK Regional Settings so my dates are dd/mm/yyyy. For some reason, when filtering dates in Excel, it wanted me to use the US settings within my code... so got it to work with mm/dd/yyyy. How can this be fixed on any other regional settings?
HI and thanks for your comment Jack. Dates are no doubt very tricky. The key is to make sure ALL of your date formats are the same. That means your regional computer settings, your excel data settings, any excel default date formats, etc. No doubt the issue is incorrect formats, so once all the date formats are exactly the same it should work well. When filtering by dates its always best to use the date code #, for example I would use ">45325" which would mean greater than today (February 3rd) when using these numbers excel will be sure to get the correct dates. You can see these numbers when you enter a date then change the format to General
I hope this helps and thanks so much.
hi Randy again thanks for the great content. I had same problem with Aust Dates, still can't get any of the date sample to work, sorry just one 15/01/2023 - None of the others worked. tried manual entry checked system settings no date formats in format cells. Odd to say the least. I might try a fresh workbook tomorrow and redo see if that helps
Hi and thanks, you will want to make sure to set the date formats in your computer, excel and in the code to all the same format such as Format(YourDate,"mm/dd/yyyy")
I hope this helps and thanks so much.
Saludos desde México! Happy New Year!
Hi randy I follow you more than 2 years you are the best in Excel. So I want to know if there is a possibility to get annual subscription
Thank you so very much, I really appreciate that @allexgil. Happy New Year to you too :) :)
HI @messaoudpolitique9208 thanks so much for your comment. You can sign up for an annual subscription as a member here: www.patreon.com/ExcelForFreelancers
I hope this helps and thanks so much.
Quick question on using "OR" criteria. You had both criteria in the same column becuase the tested values where of the same variable. Suppose you had the Fruits and Price as the column headers and wanted to use an OR such as containing apple or anything ess than 5 on the price. Can this be done since the layout would have to include a blank criteria but then it is some what of a hodge-podge on syntax since it has both columns implying "and." So maybe this cannot be done?
HI Malcom, thanks so much. You would have to expand both the the columns and the rows of your criteria to include both OR and AND options. Yes it can get a bit tricky and for this basic lesson, I did not want to confusing people.
I hope this helps and thanks so much.
Hello Randy, can you explain what field is and criteria 1. How about field= 2 , what will happen
Hi and thanks so much. When using AutoFilter, and want to filter based on more than one condition you can have multiple fields such as FIeld=1 and Field=2, This allows you to filter based on more than 1 criteria. I hope this helps and thanks so much.
@@ExcelForFreelancers yeah, thanks
Until now you did not take about string concatenation that always appears in Sheet1.Range("A1:A" & LastRow).Value , I mean "A1:A" & LastRow
Hi and thanks very much. I do combine strings often in Excel. Please check any of my email templates as i combine variables with the subject or email body. I hope this helps and thanks so much.
how to extract data when there is a blank row between the table using (currentreligion) return from partial data to entire range for worksheet
Hi and and thanks you can use the last row of data using .Range("A99999").end (xlup).row
then run the advanced filter based on the full set of data. The blank row will be excluded
I hope this helps and thanks so much.
رجاء حول اي شی یعنی من هاذا الشرح
مرحبًا وشكرًا، يتم استخدام هذا لإنشاء عوامل تصفية لبياناتك. سأعرض لك طرقًا متعددة لاستخدام هذه المرشحات. آمل أن يساعد هذا وشكرا جزيلا.
Sir who is your mentor ??
Hmm good question. I have many mentors. From a marketing standpoint, Leila Gharani is pretty amazing, from a personal development, Jim Rohn was a pioneer and someone who inspired me to work online and create courses was Brendon Burchard. Thanks for the great question.
Seriously?? Leila....
She has been very helpful to me with Excel. But??? You're doing amazing things with Excel that I haven't seen Leila do yet.. @@ExcelForFreelancers
Yes, sure her and I, are very different in her approach to Excel, but she has 2.5 MILLION subscribers. That is insane! Of course her material is much more for a broader audience than mine but still, truly amazing, and her marketing and video editing are fantastic.
Thanks again for your continued support.
@ExcelForFreelancers You'll get to a million subscribers soon go beyond.. Keep your consistency up..
Leila has worked for over 7 years on CZcams and sure has good marketing. Learn from her and thrive Sir. All the best Randy
Thank you so very much, I really appreciate that Nathaniel