I've hit a strange snag with this. The archive sheet now has 270 entries where the macro has been used to take rows of data from the active sheet to the archive sheet.
However it's now stopped transferring any further data. When the macro is run, it takes the data out of the row that has the "Yes" selected, does nothing then displays the message box, however this says 0 rows transferred, but the data just disappears , very strange... Any ideas please? I've tried to see if there is any limitations set on the number of rows but there doesn't seem to be.