Open and close Excel workbooks in the background
Posted 4th September 2014
2 comments
Use a Visual Basic for Applications (VBA) script to open secondary Excel workbooks as data sources when opening a VLOOKUP-dependent workbook.
Round to the nearest work day in Excel
Posted 31st July 2014
3 comments
Use this basic formula to round any scheduled date to the next working day (Monday to Friday) for use in workplace task planning.
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.
Add a suffix to selected cells in Excel
Posted 12th July 2014
2 comments
Use this handly VBA macro to automatically add characters to the end of values in a selected range of cells.
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.