Hi everyone,
I have just completed a simple Quiz in Excel. It consists mainly of "true or false" and "fill the box" questions.
My trouble is the following: I need to register and save the answers and results of several examined people in another sheet of the same workbook. With an equal (=) formula on the Data Base sheet I am able to transfer the answers and results from the Quiz sheet. However, different people will be using the same Excel workbook in the same computer to complete the quizzes. Therefore, I need to be able to register all the answers in their respective result card. I wonder if it is possible to set a function that would fill the second result card if and only if the first result card has data from the first quiz. Naturally, I need to do this without losing the information saved in the first result card. Could you guys help me?
By the way, my Excel workbook is in english. If you could give me a hint which formula to use I can figure it out myself in spanish.
I attached the workbook with the very important texts translated to english.
Thanks!!!
Bookmarks