Hi everyone.
Is it possible to create a data validation drop down list that is linked to another drop down list in the same workbook. Not to be mistaken with dependent or cascading drop down lists.
In other words, if I have a drop down list in Sheet1 and create the same drop down list in Sheet 2. Im hoping the user can make a selection on either sheet and the selection will show on both sheets.
For example drop down list of "cat" and "dog" on both Sheet1 and Sheet 2. User selects "dog" on Sheet1 and sees "dog" selected on Sheet 2. Then switches to "cat" on Sheet2 and sees the change to "cat" in Sheet1.
Is it possible to create a data validation drop down list that is linked to another drop down list in the same workbook. Not to be mistaken with dependent or cascading drop down lists.
In other words, if I have a drop down list in Sheet1 and create the same drop down list in Sheet 2. Im hoping the user can make a selection on either sheet and the selection will show on both sheets.
For example drop down list of "cat" and "dog" on both Sheet1 and Sheet 2. User selects "dog" on Sheet1 and sees "dog" selected on Sheet 2. Then switches to "cat" on Sheet2 and sees the change to "cat" in Sheet1.