VBA is a programming language used in Excel to record routine tasks and procedures. By creating a short script you can automate adding new data to a sheet, performing calculations and create custom functions.
If you have a worksheet with data in columns that you want to rotate so it’s rearranged in rows, you can use the Transpose feature. It lets you quickly switch data from columns to rows or vice versa
Presenting data and focusing on design when creating a dashboard seems easy enough but there are some simple things you can do to make the message clearer and quicker for the user to understand.