Refresh Multiple Pivot Tables - The Easy Way
I use pivot tables a lot. They drive multiple reports in my workbooks and it is not unusual for me to have 6 or so pivots in each spreadsheet. When the underlying data changes I spend quite a lot of...
Macro to Insert a "Last Update On:" Date Value
I have a number of summary reports that are updated by the use of a macro update button.
Sumproduct Function and Conditional Criteria
The sumproduct function is one of the most useful and powerful features of excel but the online help available from microsoft is unfortunately pretty poor.
Macro to Consolidate Data Ranges from Multiple Excel Spreadsheets
I have a lot of macro workbooks that consolidate multiple data ranges from individual tabs in the same workbook into one summary tab but today I discovered how to consolidate data ranges from different excel workbooks into one summary workbook....
The SUMIF Function using Named Ranges
Named ranges are useful in Excel as their use can make formulas much more understandable. You can name: areas of the spreadsheet, such as your data columns and rows or individual cells that may act as constants, for example the...