That works really well. Thanks for taking the time for this. I appreciate it.
I was working on some code and made a bit of headway so I will post it also. It only transfers one row at a time to a lower portion of the same document but also generates a time stamp. The time stamp also prevents the same row from being sent twice.
Your method adds to the end of the list in the destination document while I was thinking of inserting in Row 2 on the destination document. Is there a best practice for this if order of data does not matter?
Also, is it good practice to add a line as you have in case of error to goto...? I have seen this used before and I'm wondering if it's used to account for errors not foreseen?