Quote Originally Posted by theladysaphir View Post
Thank you, this works brilliantly - being able to adjust the three column names turned out very useful in the end as I needed to change the output destination.

The macro takes a bit longer to run than just using the UDF on the column repeatedly, but the result is far easier to work with and the spreadsheet is more stable.
You are quite welcome... I am glad everything ended up working out for you.