Skip to content

Easily create QR Codes in Word

G16th May 2018 

C11 comments

Did you know that it is possible to generate fully-functional QR codes in Microsoft Word using mail merge without the need for third-party plugins?

Read the full story

Add comments to Excel formulae

G29th September 2016 

C2 comments

Are your Excel formulas getting out of control? Here’s an easy method to insert comments, so that you can keep track of what’s what.

Read the full story

Merge multiple CSVs with PowerShell

G28th June 2016 

C8 comments

Use this simple PowerShell script to merge multiple CSV/TSV/TXT files into one.

Read the full story

Duplicate Excel cells multiple times

G13th April 2016 

CNo comments

Use this Visual Basic script in Microsoft Excel to duplicate cells a specified number of times.

Read the full story

Rearrange Excel columns via Visual Basic

G16th March 2016 

C15 comments

A simple VBA script for rearranging the order of columns in an Excel spreadsheet.

Read the full story

Convert CSV to XLSX via PowerShell

G9th March 2016 

C37 comments

A nifty PowerShell script that will take a delimited CSV file and convert it to a XLSX file.

Read the full story

VBA: Convert text to columns for all worksheets in Excel

G26th November 2015 

C5 comments

A small Visual Basic for Applications (VBA) script which will loop through all sheets in an Excel workbook and convert text to columns.

Read the full story

Combine multiple CSVs into one XLSX via PowerShell

G25th November 2015 

C17 comments

A convenient PowerShell script that will detect all of the CSV files in a directory and merge them into a single XLSX file. Each CSV becomes a worksheet in the XLSX.

Read the full story

VBA: Delete all Excel columns except those named

G16th September 2015 

C2 comments

Use this simple VBA script to delete all columns in a worksheet except those that are specifically named.

Read the full story

VBA: Create a list of all external data references in Excel

G15th September 2015 

C3 comments

Use this simple Visual Basic for Applications script to list every external link within an Excel workbook.

Read the full story