Hi there, I need help with Data Validation in my workbook. I have two worksheets, the first is called Data and the second one is called Dropdown. The Dropdown sheet contains three named ranges: ddTest1, ddTest2 and ddTest3. These named ranges are used in the Data worksheet to fill the data needed. My problem is that if I change the names in any of the named ranges, the existing values in the Data worksheet do not get updated with the new info. I can see the new names in the dropdown lists for future use.
How can I get the information in the Data worksheet to automatically update if there are any changes in the Dropdown worksheet?
Thank you
Data Worksheet Information:
<tbody>
</tbody>
Dropdown Worksheet Information:
<tbody>
</tbody>
How can I get the information in the Data worksheet to automatically update if there are any changes in the Dropdown worksheet?
Thank you
Data Worksheet Information:
Data1 | Data2 | Data3 |
Alpha | Red | Round |
Beta | Yellow | Round |
Alpha | Yellow | Triangle |
<tbody>
</tbody>
Dropdown Worksheet Information:
ddTest1 | ddTest2 | ddTest3 |
Alpha | Red | Square |
Beta | Blue | Round |
Sigma | Yellow | Triangle |
<tbody>
</tbody>