May 19 2020 06:39 PM
May 19 2020 10:57 PM
@johnnyg00 use attached file.
You need to update cells in "Yellow", rest is auto calculated
May 20 2020 06:15 PM
that's i awesome thank you but how do i do it so that they don't see the correct answer until they input answer in B column
May 20 2020 11:06 PM
@johnnyg00 okay, I have moved correct answers to sheet 2.
Once you update Correct Answers, make that sheet 'Very Hidden' so that users can't see it.
HOW TO MAKE SHEET VERY HIDDEN:
https://www.ablebits.com/office-addins-blog/2017/12/20/very-hidden-sheets-excel/
refer to title "Make a worksheet very hidden by changing its Visible property"
Note: This is not my blog, it's just for reference.