Need Help Protecting Cells

[MariPip]

Hello
I am in desperate need for help with this, so any answer would be really useful!
I have two worksheets, lets call them Worksheet1 and Worksheet2.
Worksheet 1 is a sample formulary with a reset button, so that everytime you fill it and then press the button, a pdf of it is created and the cell on to which we insert the details of each sample are deleted.
Worksheet 2 is a Summary formulary, which collects information from each sample (sample number and some results), which it gets from Worksheet 1 using a simple =IF(...) function.
My problem is that when I reset Workhseet 1 I lose the data that had gone onto Worksheet 2.
So I wish to find a way to lock the cells in Worksheet 1 after they have collected the information from Worksheet 1, or something of that sort.
THANK YOU!

[sakmsb]

Hello
I am in desperate need for help with this, so any answer would be really useful!
I have two worksheets, lets call them Worksheet1 and Worksheet2.
Worksheet 1 is a sample formulary with a reset button, so that everytime you fill it and then press the button, a pdf of it is created and the cell on to which we insert the details of each sample are deleted.
Worksheet 2 is a Summary formulary, which collects information from each sample (sample number and some results), which it gets from Worksheet 1 using a simple =IF(...) function.
My problem is that when I reset Workhseet 1 I lose the data that had gone onto Worksheet 2.
So I wish to find a way to lock the cells in Worksheet 1 after they have collected the information from Worksheet 1, or something of that sort.
THANK YOU!

As worksheet2 is getting data from worksheet1 via a formula, once the data on sheet1 is reset, data on sheet2 would be lost.

As a workaround, you can record a macro that will copy the data in sheet2(after collecting data from sheet1) and paste it as values.