Skip to content

Automatically update Pivot Tables in Excel

Posted 15th July 2014

No comments

A simple VBA script that refreshes (updates) all Pivot Tables within an Excel workbook after any change to a worksheet.

Read the full story...

Automatically select data-containing cells in Excel

Posted 29th January 2014

No comments

This VBA script will automatically select data-containing cells and exclude all empty cells in an Excel worksheet.

Read the full story...