Score sheet adding numbers

Question

I created a survey for courses.  Each question from the survey returns a score.

I want to enter the score from each question into one sheet (see Score sheet Participant), and have the score adding into another sheet (see Reference Scoring sheet).  Each time I am done with a participant, I want to clear the Score sheet Participant but keep the Reference Scoring sheet intact and adding the numbers. I'm using the same score sheet for each participant.

Score sheet Participant  (same sheet for each participant)

Question 1	3
Question 2	5

Reference Scoring sheet

Question 1	3
Question 2	5

Thank you.

Moved from: Office /Excel /Windows 10 /Office 2016

Answer 1

That would depend upon the complexity of the project.

A basic layout could be several cells to fill out on the input sheet then transfer that data to a user's sheet then input sheet cleared for next user input.

A non-basic project would probably involve a UserForm for input

That type of Data Form collecting workbook can be searched for on the internet.

I will upload a basic workbook to my onedrive site for you to look at.

Worksheet event code is in Entry sheet module. . . .right-click sheet tab and "View Code" to see and alter the code.

Click on my face picture to open my profile then click to open My OneDrive Site

Workbook name is Survey_Multi_Names.xlsm

Gord

Answer 2

Gord,

Thank you,

How hard would it be to learn it and do it with VBA

Eric.

Answer 3

This cannot be done using formulas.

When you delete the data on the input sheet it would be gone from both sheets.

Either you do it manually or use VBA

Gord