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

[Admin]

I would say try yourself first and comeback if it not worked. That way you will learn something.

[rich_cirillo]

Hi Admin

I think the VBA code is excellent....I will try and see what I get

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_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

[Admin]

Hi

It should be L37 and L21 rather than 137 and 121.

[rich_cirillo]

Hi Admin

Thanks

Can we finish this with a final alteration to the Clear Data code...can the Clear Data button only be functional once the data for that week has been entered into Records sheet...once the data has been Transferred to the Record Sheet by pressing the Transfer Data To Records button then the Data can be cleared

Thanks

Rich