I've set up Dependent Data Validation so when a specific Session is selected only specific options are available in the next two columns. However, the third column the user is to input a number. The only restriction is for the Session called Previous Group. Those two dependent validation columns read "Reported Above" but when i set up a dependent validation for the third column it makes the whole column dropdown only regardless of Session. How can I tell it to auto-enter Reported Above if Previous Group is selected, or if the next two columns show as Reported Above?Using Excel365
[TABLE="width: 915"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Session[/TD]
[TD]Topic1[/TD]
[TD]Topic2[/TD]
[TD]#Attending[/TD]
[TD][/TD]
[TD]Session[/TD]
[TD][/TD]
[TD]Group[/TD]
[TD][/TD]
[TD]PreviousGroup[/TD]
[TD][/TD]
[TD]One_t
ne[/TD]
[/TR]
[TR]
[TD]Group[/TD]
[TD]Class B[/TD]
[TD]Class A[/TD]
[TD] [/TD]
[TD][/TD]
[TD]Group[/TD]
[TD][/TD]
[TD]Class A[/TD]
[TD][/TD]
[TD]Reported Above[/TD]
[TD][/TD]
[TD]Class A[/TD]
[/TR]
[TR]
[TD]PreviousGroup[/TD]
[TD]Reported Above[/TD]
[TD]Reported Above[/TD]
[TD] [/TD]
[TD][/TD]
[TD]PreviousGroup[/TD]
[TD][/TD]
[TD]Class B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Class B[/TD]
[/TR]
[TR]
[TD]PreviousGroup[/TD]
[TD]Reported Above[/TD]
[TD]Reported Above[/TD]
[TD] [/TD]
[TD][/TD]
[TD]One_t
ne[/TD]
[TD][/TD]
[TD]Class C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Class C[/TD]
[/TR]
[TR]
[TD]One_t
ne[/TD]
[TD]Class A[/TD]
[TD]Class B[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Group[/TD]
[TD]Class A[/TD]
[TD]Class C[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PreviousGroup[/TD]
[TD]Reported Above[/TD]
[TD]Reported Above[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 915"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Session[/TD]
[TD]Topic1[/TD]
[TD]Topic2[/TD]
[TD]#Attending[/TD]
[TD][/TD]
[TD]Session[/TD]
[TD][/TD]
[TD]Group[/TD]
[TD][/TD]
[TD]PreviousGroup[/TD]
[TD][/TD]
[TD]One_t

[/TR]
[TR]
[TD]Group[/TD]
[TD]Class B[/TD]
[TD]Class A[/TD]
[TD] [/TD]
[TD][/TD]
[TD]Group[/TD]
[TD][/TD]
[TD]Class A[/TD]
[TD][/TD]
[TD]Reported Above[/TD]
[TD][/TD]
[TD]Class A[/TD]
[/TR]
[TR]
[TD]PreviousGroup[/TD]
[TD]Reported Above[/TD]
[TD]Reported Above[/TD]
[TD] [/TD]
[TD][/TD]
[TD]PreviousGroup[/TD]
[TD][/TD]
[TD]Class B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Class B[/TD]
[/TR]
[TR]
[TD]PreviousGroup[/TD]
[TD]Reported Above[/TD]
[TD]Reported Above[/TD]
[TD] [/TD]
[TD][/TD]
[TD]One_t

[TD][/TD]
[TD]Class C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Class C[/TD]
[/TR]
[TR]
[TD]One_t

[TD]Class A[/TD]
[TD]Class B[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Group[/TD]
[TD]Class A[/TD]
[TD]Class C[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PreviousGroup[/TD]
[TD]Reported Above[/TD]
[TD]Reported Above[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]