Civil Engineering Projects
Macro 67: Adjust All Pivot Data Field Titles
When you create a PivotTable, Excel tries to help you out by prefacing each data field header with ...
Macro 66: Hide All Subtotals in a PivotTable
When you create a PivotTable, Excel includes subtotals by default. This inevitably leads to a
...
Macro 65: Make All PivotTables Use the Same Pivot Cache
If you work with PivotTables enough, you will undoubtedly find the need to analyze the ...
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 ...
