How to lock data on one row then move to the next

Status
Not open for further replies.

md55mrd

New Member
Joined
Nov 17, 2017
Messages
8
I've added the link to the spreadsheet that I currently have.
Sheet 1 gets updated weekly and the information updates to sheet 2 but I want to be able to keep the data in sheet 2, remove the data from sheet 1 and then add new data the next week and have it update on sheet 2 under the new week and so on. I would also like to lock the data after each entry so that it can't be deleted or modified.
I've added the link to my spreadsheet attached via dropbox. Please let me know if I've done this entire thing incorrectly or what tweaks need to be made. If code is being given to me I will probably need the exact way to do it because I am beyond a beginner with VBA.

https://www.dropbox.com/s/izrzrt2xcj...unts.xlsx?dl=0

Thanks for all the help and information.
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Status
Not open for further replies.

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top