neverblink
New Member
- Joined
- Sep 1, 2021
- Messages
- 1
- Office Version
- 2010
- Platform
- Windows
I have a data sheet that holds test scores by date and student. Each column heading is the date, student, and tests 1 - 20 across columns.
I created a user form where the teacher enters date and student and the test number and score. But I haven't been able to capture the test score under the appropriate column on the data sheet.
The data sheet should look like this after user form entry:
Date Student test1 test2 test3 test4........to test20
8/1/21 JDoe 30 90
8/2/21 John Doe 25 75
Looking for suggestions on how to populate the tests via the user form.
I created a user form where the teacher enters date and student and the test number and score. But I haven't been able to capture the test score under the appropriate column on the data sheet.
The data sheet should look like this after user form entry:
Date Student test1 test2 test3 test4........to test20
8/1/21 JDoe 30 90
8/2/21 John Doe 25 75
Looking for suggestions on how to populate the tests via the user form.