从“sheet1”到“sheet2”的存档数据

I have the following code to archive data from "sheet1" to "sheet2": and when executed, it keeps overwriting existing data already present in the "sheet2" rows from previous archive exercise. Looking for help in having the code seek the next blank row vs. overwriting existing data. I have 2 header rows so it should commence with row3. Option ExplicitI have the following code to archive data from