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