Filtering Pivot Tables Dynamically
Автор: VitoshAcademy
Загружено: 2025-02-21
Просмотров: 1064
Hey there! 👋 Welcome to the channel of VitoshAcademy! 🌟
⚽ Ever wondered how to make your Excel pivot tables smarter and more dynamic? In this video, we will dive into Excel VBA to create a powerful tool that filters pivot tables based on user selections. We will use real-world English football (soccer) statistics to make it fun and practical!
🧠 What You Will Learn:
🔹 How to extract filter selections from one pivot table and record them in Excel.
🔹 How to use VBA to dynamically filter another pivot table based on those selections.
🔹 Data used - football teams that have won English trophies in the last 11 years (2014-2024).
🔹 Step-by-step VBA coding with live debugging.
⏱ Time Stamps:
00:00 - Intro & Why This Matters
00:55 - Setting Up the Football Data & Pivot Tables
06:53 - Extracting Filter Selections with VBA
10:30 - Filtering a Second Pivot Table Dynamically
14:18 - Summary & How to Apply This to Your Projects
📂 More Resources:
🔹GitHub with the Excel file - https://github.com/Vitosh/Excel_VBA_P...
🔹GitHub with general VBA code - https://github.com/Vitosh/VBA_personal
🔹Blog - https://www.vitoshacademy.com/vba-aut...
Let me know what you think in the comments. Do not forget to 👍, subscribe, and hit the 🔔 to stay updated with more Excel and VBA tutorials! 😊
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
