Split Data Into Multiple Workbooks With The Excel Advanced Filter And VBA

In this tutorial, I show you how to split an Excel List into separate workbooks using the Excel VBA Advanced Filter. You get to see me coding a real-world problem i.e. "how the code is baked" with mistakes and corrections and then view the final product. This tutorial processes an Excel Customer Order List into separate workbooks by filtering on the Order city and then looping through each city and performing a VBA advanced filter on each city in order to create a new workbook for that city. The Excel VBA code then saves that workbook with the city name. ✅ 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    • Excel Advanced Filter   ✅ You can get the sample workbook to follow along at https://www.businessprogrammer.com/ex... ☕ 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 #excel #cheltenham DISCLAIMER: This video and description contain affiliate links, this means if you click on one of the product links, I might receive a small commission if bought with 24 hours. If you do use one of the links, thanks I appreciate it.