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.