Automatic Pivot Table Refresh
A super annoying thing about Excel is that pivot tables require manual refreshes. This can easily be forgotten by a user that updates source data in a workbook and expects …
Parsing Repeated Data into Pivotable Format in Excel
Sometimes you gain access to structured data but it isn’t a straightforward Copy and Transpose job to get the data into a useful format for analysis or database ingestion. To …
Open Selected Links with Wait using Excel
If you have the need to open a bunch of links with Excel, just use this simple VBA macro to open them all in your default browser after they have …