No im afraid not Japan Dave. Your file only copies the one row and copies accross the same row.

I would like the macro to move accross one row, one at a time until it comes to the empty cell.



Shil