copying a range to first empty row is copying over data

[jseufert]

I have a form, that is to be used repeatedly. The info is parsed to a temp sheet in the same workbook where it is organized correctly and then copied to a different workbook, a batch file. I have two problems. 1, it's duplicating the first three rows of data from my source file when pasting to my destination file. 2, It's overwriting every previous row of data in my destination file instead of finding the first empty row and concatenating the data.

Heres my code.

Please Login or Register  to view this content.

[shg]

Maybe like this (untested):

Please Login or Register  to view this content.

[jseufert]

Thank you very much, works like a charm. Sir, I owe you a great debt of gratitude.

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save