Thanks tigeravatar,

The source spreadsheet is a bit long winded to access on company's intranet.

Was trying to find a clever way to automate the process.