Thanks, Jindon. I don't see the formulae that's being used to achieve this. To make use of this I would be entering my data in a second sheet on the Mastersheet workbook and then copy and paste the data into a new csv file?

Thanks for your help!
chrlyd