Linking multiple data validation drop-downs

[mark9988]

Hello Friends -

Is there a way to have a set of data validations drop-downs that update accordingly based on the selection from any other drop-down?

For example, by selecting "Hot" from any drop-down from the set of 3 below, is there a way for the remaining Data Validation drop-downs to also update to "Hot" and the output in cell D9?

Book1.xlsx
	C	D	E	F	G	H
6
7
8		Output			Data Validation 1
9		Hot			Hot
10
11
12
13					Data Validation 2
14					Hot
15
16
17
18					Data Validation 3
19					Hot
20
Sheet1

Cell Formulas
Range	Formula
D9	D9	=G9

Cells with Data Validation
Cell	Allow	Criteria
G9	List	Hot, Warm, Cold
G14	List	Hot, Warm, Cold
G19	List	Hot, Warm, Cold

 

[mark9988]

bump