joecrabtree wrote:
Hi

Thats great, it splits the data, i.e puts a new row in between each
set. It then creates the new worksheets where it will paste the data,
however the worksheets remain blank, as it doesn't paste the data to
them. Any Ideas?


Sorry - tested OK for me.

Working example at www.niksally.f2s.com/temp/datasplit.xls

Nik