Button to copy range to new worksheet

I have been trying (without success) to add a control button, that when clicked will copy a specified range eg A1 to F6, to a new worksheet. I will then delete the original data and enter new, then when i click the button again it will copy the second set of data to the new worksheet adding it on to the first data. Any help appreciated.

Try this.
I can't test it right now, but it should help.

Please Login or Register  to view this content.

Thanks for quick reply, but how do I use this. Do I attach the code to a button or is this a macro?

Hi, thanks, that seems to work as I wanted. If you can add extra lines to delete original data that would be great.
Thanks again

Thank you, thats great, just one thing, is it ok to delete sheet 3?

Fotis1991, I like the code provided and want to implement something similar on a worksheet of mine. Does the code provided retain the original formatting on the first sheet being copied from?

Thanks so much!

Jan