VBA Code To Move Data From One Sheet To Another And Delete From Source Sheet

[rich_cirillo]

Hi Admin
I renamed the sheets and changed in the VBA code but now i get a Runtime Error - 1004 Application defined-or object defined error...was working exactly as programmed until i changed the sheet names..

Can the following be altered...this will finish all requirements

I added all the data in Sheet 1 and before I pressed the button "transfer to sheet 2" I hit the "Clear Data" button and it deleted the data before I transferred it to Sheet 2....can the Clear Data button only clear data if the data has been transferred to Sheet 2 first...can a message "Transfer data to sheet 2"

Thanks

Rich