[QUOTE=xladept;4881108]Well - I changed the sheet name to correspond to the latest RESET sheet and it seems to work nicely:


Thanks for the resonse.

I run the code and get the contents copied to the new sheet named RESET.
But some of the columns are not filled with data.
Columns N,W.AQ,AZ and CC are left blank. whereas these are supposed to be filled when i run the code.