Also, each time I run the userform it overwrites the data that was already there instead of pasting it in the row beneath the last row of data.

What can I write into my code to fix this and where do I put it?