Nobody Told You Excel VBA Could Do This – Auto-Generated Org Charts! скачать в хорошем качестве

Nobody Told You Excel VBA Could Do This – Auto-Generated Org Charts!

This very special Excel VBA tutorial. In this video we do something I believe has never been fully demonstrated before in Excel VBA – we’re going to build a modern, dynamic organizational chart that includes names, designations, and even employee photos, all generated automatically from data using VBA. To make this even more exciting and relatable, we’ll use the real-world example of Apple’s leadership structure, so you can see how this approach can be applied to any company or organization. What makes this project stand out is that most VBA org charts have always been very simple, either text-only or manually designed. But this solution creates a fully styled org chart, using a custom-designed shape template, complete with automatically connected shapes and photos filled directly inside circular frames, all powered by VBA code. If you’ve ever wanted to take your Excel + VBA skills to the next level, and learn how to automate not just data but also design, then this is the video you’ve been waiting for. ---- 00:00 Intro 01:44 Dataset and output sheet overview 04:02 Creating the template shape for the org chart 08:36 Logic behind the org chart structure 11:11 Live coding the org chart generator from scratch 37:40 Running the macro to generate the org chart (demo) 38:40 Outro ---- Testing File link: https://www.dropbox.com/scl/fi/jomjem... Connect with me on social: LinkedIn:   / siddharthrout   Facebook:   / msexcelvba   Instagram:   / altf11ninja   X: https://x.com/AltF11Ninja Stackoverflow: https://stackoverflow.com/users/11405... #ExcelVBA #MSExcel #Excel #ExcelMacro #VBAExcel