Split Data Into Multiple Workbooks With The Excel Advanced Filter And VBA
7.7 هزار بار بازدید -
4 سال پیش
-
In this tutorial, I show
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.
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.
4 سال پیش
در تاریخ 1399/10/17 منتشر شده
است.
7,759
بـار بازدید شده