Nice job Paul , there was an error on "Set wsIn" err 9, have fixed it and added the " " on the sheets.
I have rem'd out the clear cells on sOutput just in case Susi wants to keep adding to the sheet ?
Susi
In the text there was something about removing the "Unknowns" ? is it just that field or the complete row ??
Posted a copy workbook back so you can see what its doing ok.
Reply With Quote