Is it possible to write a command that will send all data captured on sheet 1 to another sheet as an archive? In other words, users will enter data on sheet 1, once they have reached row 100, all the data on row 1 - 100 will move to the archive spreadhseet and clear the rows on sheet 1.

If this is still confusing let me know.

Thanks