I am an enthousiast reader of the blog ‘Option Explicit’. I changed the formula (see below) and made a version for showing Years and Months. Now you can use this tool for Management Information. This fantastic tool, combined with Named Dynamic Ranges gives the ultimate solution for making awesome interactive dynamic Excel charts. As soon as possible I will show you an example.
Bert van Zandbergen, Beekbergen – The Netherlands
You can download the file, here: Rollover_MI model version 1.xlsm
Make Your Excel Spreadsheet into a Bitmap Image With This Excel Magic Trick
Excel Data Visualization: Presidential Approval Ratings with Slicers & Power Query – Chart Tricks
Advanced Excel Tutorial – VLOOKUP() Speed in Excel | Excel TV, Episode 54
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.