The following sample table (Table1) has some repeating GroupName values (Group1 repeats 3 times, Group4 repeats twice) and some repeating questions (Question1 occurs 4 times, Question2 occurs twice).
The answers may be the same for identical questions, or different, if they are in a different group. Group1 may have an answer to Question1 of "Answer1" or "Answer2" or "Answer999" etc. Group2 may have an answer to Question1 identical to the above, or different. Usually, the answers are the same though, so it would be helpful when you have 10,000 rows like this to say "this is a typical answer, apply this answer to all identical questions except the ones I exempt".
Here is a snapshot of my example table:
Now, this could easily be accomplished with some sloppy VBA to just copy the values to all identical rows except ones specified in a pop up of some kind, but that isn't very user friendly. I'm looking for a more robust/native/normalized way to organize and present this data for data-entry users so that they can view, for example, all Question1's in their own table/form and answer them for multiple rows (varying Groups) in one user action.
Any help greatly appreciated!
Here is a download of the sample database:
http://www.filedropper.com/question1_1