Whoops, sorry, I spoke too soon.. ..on checking, there are still problems (need to find the first empty row to start from on sheet1 - and all the others - and it goes to row30 on sheet1) but I think you've given me what I needed to get it sorted...the logical flaw would seem to be that I need a header column << edit: (I mean row, not column)

TA,
John