Skip to content

Dear Internet Explorer user: Your browser is no longer supported

Please switch to a modern browser such as Microsoft Edge, Mozilla Firefox or Google Chrome to view this website's content.

Round to the nearest work day in Excel

Posted 31st July 2014

No comments

Use this basic formula to round any scheduled date to the next working day (Monday to Friday) for use in workplace task planning.

Read the full story...

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...

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.

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...