Some of my monthly reports are pretty locked down to the current month for business reasons, and using a small Macro to update all of my Pivots is handy. This Macro is also handy if you do not want to give the user options to change the month by a Slicer or Timeline function. You can create a Macro to update the filters to the new month’s data or any month’s data by updating them altogether. Most Excel dashboards are driven by Pivot Tables and Slicers. If you have to update your Excel dashboard every month to display the new months’ analysis, especially if you have a lot of Pivot Tables, then it can take time to change filters on multiple reports. Update Multiple Pivot Table Controls With A Click. So, this is my second reason as to why I use Excel Macros. A few controls to navigate, choose dates and print selected charts and data can make all the difference. If you need to get users using your Excel Dashboard, giving a few user-friendly controls can be the difference between used and not used. You will probably create Excel dashboards for people who have limited experience navigating around an Excel solution. Create yourself a handy week after week time-saving Macro. If you find yourself deleting columns, moving columns, or changing the data type week after week after week, then spend the time recording your data transformation steps. So if you find yourself carrying out the same data processes on your data to get it just how you need it, then record a Macro. I use Macros to transform the information I get every week into the format I need to update my reports with the latest data. But it is data, and we can do stuff with it. Let’s face it, sometimes it is pretty (or not pretty at all!) awful. Usually, our data to update our reports is in a raw state. Avoiding repetition is my principal reason for using Macros in my reports.

There is room for both, one method does not necessarily replace the other. Now, you may be a Power Query user (I am myself), and Power query DOES eliminate repetitive tasks, but not all tasks can be done in Power Query. So, my first reason I want to share as to why I use Excel macros is that they avoid repetitive tasks. Yes, I have FOUR great reasons why I use Excel macros. If you want to up your Excel VBA skills then this is my recommended VBA Course. So, today let’s explore my TOP FOUR reasons for including Excel Macros in your Excel dashboard reports.

In this post, we’ll discuss four reasons to start using macros in your Excel reports and dashboards. Do you use macros in your Excel reports and dashboards? If not, you should! Macros can save you a lot of time and hassle when creating these documents. Time for some more Excel Macro fun on a Monday.

How to use mmult in excel with macros