Hello Steve,
It appears that you are transferring a complete, hard-coded data block to the second sheet (always to the same area: "A2:I") which is why the older data is being overwritten. You may have to try a different tack, such as:-
where sheet1 (Call in Log) is the source sheet and sheet2 is the destination sheet (Complete).
This will add the transferred data to the bottom of the existing data in sheet2.
(You could do the same for the second line of code in your opening post and add it in to the above code).
I hope that this works for you.
Cheerio,
vcoolio.
Bookmarks