apologies. - yes total code to actually do the above. the code i do have (which i also got from here) creates individual CSV files from the excel spreadsheet http://http://www.excelforum.com/excel-programming-vba-macros/861933-vba-to-save-multiple-worksheets-as-separate-csv-files-using-name-of-worksheet.html?p=2939518#post2939518..