How to retain data

[pareng_kitz]

I am a beginner and need help regarding my report. I have an excel file containing my Quality evaluation form. The Qual Eval Form is where i grade the quality of the ticket i am evaluating. On the second sheet are the grades and the criteria that was not met. Now my problem is i want to be able to mark the criteria that was not met per user by only working on the first sheet. I was provided by a friend here with a formula that would mark the criteria when i eval the first sheet. I need to eval two tickets per month and whenever i make changes to sheet one it changes the data on the second sheet. How can i make the data to retain on the second sheet even if i do anything on the first sheet?

i wanted to be able to use the sheet 1 to grade users and mark the failed criteria as per data on sheet 1 in sheet 2 and retain the marked criteria per user in sheet 2

this is the formula im using to marked sheet 2 automatically using sheet 1. But i wanted the data to be retained even i choose another user to grade.

=IF(AND('Exelon QAP Form Template'!E3="Alalaine Rabe Quintans",'Exelon QAP Form Template'!I13="No"),"X","")

In that case i can create a pivot table to know which criteria my team is failing. Hope this explained it and you guys can help me. Thanks you