4
How to Copy or Import VBA Code to Another Workbook
Bottom Line: Learn how to insert VBA code into your worksheets using four different techniques.
Skill Level: Beginner
43
Excel Table of Contents that Automatically Updates
Bottom Line: Learn to create a Table of Contents sheet that automatically updates whenever changes are made to sheets in an Excel workbook.
Skill Level: Intermediate
10
Macro Buttons to Add Fields to Pivot Tables
Bottom Line: Learn how to create simple macro buttons that users can click to instantly add or remove fields to Excel pivot tables.
Skill Level: Intermediate
5
2 Ways to Assign Keyboard Shortcuts to Macros
Bottom Line: Learn two different ways to create keyboard shortcuts to run macros, and discover the pros and cons for both methods.
Skill Level: Intermediate
44
Refresh Pivot Tables Automatically When Source Data Changes
Bottom Line: Learn how to use a simple macro to refresh pivot tables automatically whenever changes are made to the source data. I also share a non-macro solution to update the pivot tables when the file is opened. Includes video tutorial and Excel file download.
Skill Level: Intermediate
How to Enable the Developer Tab in Excel for Windows
Bottom Line: Learn how to enable the Developer tab on the ribbon so that you can access commonly used functions for Macros, VBA, and Add-ins. Works on all versions of Excel for Windows (Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, and Office 365).
Skill Level: Beginner
1
Keyboard Shortcuts for the VBA Intellisense Drop-down Menu
Bottom line: Learn two keyboard shortcuts for displaying the Intellisense menu, so you can autocomplete words in the VB editor.
Skill level: Intermediate
8
How to Create VBA Macro Buttons for Filters in Excel
Bottom line: Learn how to create macro buttons that apply filters to multiple columns in a filtered range or Table.
Skill level: Intermediate
How to Clear Filters with VBA Macros
Bottom line: Learn how to clear all filters, and filters on a single column with VBA macros. Includes code examples for regular ranges and Excel Tables.
Skill level: Intermediate
1
How to Filter for Colors & Icons with VBA Macros in Excel
Bottom line: Learn how to apply color and icon filters with VBA. Includes examples for filtering for font color, fill color, and conditional formatting icons.
Skill level: Intermediate
