Learn
Macro 64: Create a PivotTable Inventory Summary When your workbook contains multiple PivotTables, it's often helpful to have an inventory summary ...
Macro 63: Refresh All PivotTables Workbook It's not uncommon to have multiple PivotTables in the same workbook. Many times, these PivotTables ...
Macro 62: Create a Backwards- Compatible PivotTable If you are still using Excel 2003, you may know about the compatibility headaches that come ...
Macro 61: Show Filtered Columns in the Status Bar When you have a large table with many columns that are AutoFiltered, it is sometimes hard to ...
Macro 60: Create a New Sheet for Each Item in an AutoFilter One of the most common tasks an Excel user is confronted with is separating a data ...
Macro 59: Copy Filtered Rows to a New Workbook Often, when you're working with a set of data that is AutoFiltered, you want to extract the ...
Macro 58: Selectively Hide AutoFilter Drop-down Arrows It goes without saying that the AutoFilter function in Excel is one of the most useful. ...
Macro 57: Hide All Rows but Those Containing Duplicate Data With the previous macro, you can quickly find and highlight duplicates in your data. ...
Macro 56: Highlight Duplicates in a Range of Data Ever wanted to expose the duplicate values in a range? The macro in this section does just ...
Macro 55: Clean Up Non-Printing Characters Sometimes you have non-printing characters in your data such as line feeds, carriage returns, and ...
