Create Clickable Tabs Inside an Excel Sheet
About this lesson
How to create clickable tabs inside a single Excel sheet. Take our Data Analyst Program here: https://www.careerprinciples.com/career-track/the-data-analyst-program 🆓 DOWNLOAD the Free Excel file and VBA code for this video: https://careerprinciples.myflodesk.com/wdii7z8ze3 in this video, I'll show you how to create tabs inside an Excel sheet that are fully clickable, change colors when selected, and the corresponding data updates automatically. This way you don't need to have dozens of worksheets; instead, have everything in one sheet with multiple tabs. For this, we'll be using shapes, named ranges, and the filter function to dynamically change the results when we click on a certain month. To tie this all together, we'll be using VBA code to create macros for each of the tabs. I'll also show you a no-code alternative using hyperlinks in Excel. LEARN: 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 🔥 Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics 🚀 All our courses: https://www.careerprinciples.com/all-courses ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00 - Page Setup 2:52 - Dynamic Formula 4:25 - VBA Code Solution 7:30 - Changing the Number of Tabs 9:30 - Page Formatting 11:27 - No-Code Alternative
DeepCamp AI