Excel VBA reuseable copy and paste below last cell

[quanziee]

I'm sorry, it only says "type mismatch" when I only fill in information for one person. I have also found a problem when I was playing around with the code. Sometimes, the information will get transferred to cells that are way below where they are supposed to be. I'm not exactly sure about the root of this problem.