VBA: Create a list of all external data references in Excel
Posted 15th September 2015
4 comments
Use this simple Visual Basic for Applications script to list every external link within an Excel workbook.
Applying dates to normalised data in Excel
Posted 19th July 2015
No comments
Use this formula to apply dates to all variables in a normalised linear list data set in Excel.
VBA: List all formulae in an Excel workbook
Posted 2nd July 2015
2 comments
Described is a convenient method for using VBA scripts to extract every formula from a Microsoft Excel workbook and create a list of them in a separate sheet for later reference or backup.
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.
Automatically add columns and formulae then fill-down in Excel
Posted 21st January 2015
5 comments
Some simple VBA code to add columns in Excel, insert specific formulae at the top then fill-down to the bottom of the sheet.
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.
Script to list image files by size and resolution, export to Excel
Posted 24th September 2014
9 comments
Instructions for using PowerShell to export a list of images and their properties to Excel as a tab-delimited CSV.