S Shay A Member Aug 29, 2016 #1 Hello, If I use it this feature, and choose a list as the source for Data Validation, will it be updated dynamically? If I use the Indirect function? TY
Hello, If I use it this feature, and choose a list as the source for Data Validation, will it be updated dynamically? If I use the Indirect function? TY
Chihiro Excel Ninja Aug 29, 2016 #2 Depends on your Named range (list) reference. To make it dynamic. You'd usually use one of below. 1. Use Table Column for named range. 2. Use Formula. Offset(Cell Ref,0,0,COUNTA(Col Ref),1) Or variations of above.
Depends on your Named range (list) reference. To make it dynamic. You'd usually use one of below. 1. Use Table Column for named range. 2. Use Formula. Offset(Cell Ref,0,0,COUNTA(Col Ref),1) Or variations of above.
S Shay A Member Sep 9, 2016 #3 Hi, and using a dynamic range will ensure that the data validation gets longer/shorter if the source changes? TY
Hi, and using a dynamic range will ensure that the data validation gets longer/shorter if the source changes? TY
