У нас вы можете посмотреть бесплатно Filtering Pivot Tables Dynamically или скачать в максимальном доступном качестве, видео которое было загружено на ютуб. Для загрузки выберите вариант из формы ниже:
Если кнопки скачивания не
загрузились
НАЖМИТЕ ЗДЕСЬ или обновите страницу
Если возникают проблемы со скачиванием видео, пожалуйста напишите в поддержку по адресу внизу
страницы.
Спасибо за использование сервиса ClipSaver.ru
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! 😊