Excel VBA Advanced Filter Examples

Video Description

How to set up the advanced filter in Excel with multiple criteria and range examples. In this tutorial and case study, I use the advanced filter on customer data to extract subsets of the Excel data to a range on the same Excel worksheet, a range on a different worksheet and to a completely different workbook. This tutorial demonstrates using the advanced filter to find rows with blank cells to report customers who have not yet received their orders. Combining the Advanced Filter with Excel Tables and Sumif formula to get the best of both worlds, in this case getting a distinct list of customers and their order values. Building out complex criteria to get missing orders by city. Walking through the thought process to write a macro using the advanced filter to create sub-reports by state. ✅ Excel VBA Programming for Dummies (affiliate) with reviews https://amzn.to/3lhnWOy​ ✅ O'Reilly writing Excel Macros With VBA https://amzn.to/3tmPm8M This playlist covers all my advanced filter videos in this series. ✅ Excel VBA Advanced Filter Playlist https://www.youtube.com/playlist?list=PLQORZjfSPqSmGAxfXk8Qb9uIQ6F9v1mop You can get the sample workbook to follow along at https://www.businessprogrammer.com/excel-vba-advanced-filter-tutorial/?utm_source=YouTube&utm_medium=YouTube-Redirect&utm_campaign=Go-Link-on-video ☕ If you found this tutorial helpful consider supporting this channel with a steaming hot cup of coffee... https://buymeacoffee.com/seanjohnson ☕ Video Production =============== Sony Camera: https://amzn.to/3mqyqfu Elgato HDMI Stream Capture: https://amzn.to/2Yfyrum Microphones ----------- Screen Casting: https://amzn.to/3a2TnHN Microphone and Arm : https://amzn.to/3iwvL2S Talking To Camera: https://amzn.to/3FqXI6b Video Kit ------------- Lights Elgato video Lights: https://amzn.to/3sSK3xg Background Light: https://amzn.to/3uTXyPh Note Taking ----------- Rocketbook reusable notebook https://amzn.to/3sSK3xg #ExcelVBA #AdvancedFilter DISCLAIMER: This video and description contain affiliate links, this means if you click on one of the product links, I’ll receive a small commission. If you do use one of the links, thanks I appreciate it.