Format mail-merge date fields in Microsoft Word
Posted 16th July 2015
7 comments
Microsoft Word will format dates as mm/dd/yyyy as the default in mail merge documents. The field codes can be changed to enable dates in any format.
Easily generate Code 128 barcodes in Excel
Posted 29th May 2015
80 comments
This simple methodology can be employed to reliably generate Code 128 barcodes in Excel.
Combining R1C1 and A1-style cell referencing in Excel
Posted 11th May 2015
4 comments
Use R1C1 cell referencing in Excel equations whilst the programme is still set to A1-style.
INDEX MATCH instead of VLOOKUP
Posted 22nd January 2015
1 comment
INDEX MATCH represents a much better way to search for data in Excel tables than VLOOKUP because this combination is much more versatile.
VLOOKUP in Excel with multiple criteria
Posted 3rd December 2014
No comments
An alternative to VLOOKUP in Excel that permits a search based on multiple criteria.
Sum of Column B, based on values in Column A
Posted 28th November 2014
No comments
Use an array formula to calculate selected values in one column, based on parameters in another.
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.