Can you make Data Validation list dynamic?
How do you validate dynamic data? In Excel, you can validate dynamic data using a dynamic drop down list. This is done by selecting the source for the drop down list as the range where new dynamic data will be added later.