Paste data build list

[Weazel]

Ok, maybe I'm just having a brain freeze....

I'm trying to build a running list of numbers that are copied from another application in groups of 50.

I paste these numbers in a sheet that concatenates them to be used in yet another application.
This part works fine. Once concatenated, the original pasted list is deleted.

What I need to do is have the pasted list copied to a new sheet and each subsequent pasting added to it so I have a running list of all the data that was pasted throughout the day.

Thanks for any help

 

[Weazel]

http://www.mrexcel.com/forum/showthread.php?459416-Copy-paste-into-continuous-list

Thanks for this VoG, I appreciate it.