Is there a way to populate Data validation list from data range for certain selected range

Hello:

Please refer to attached file.
Is there a way to create Data Validation automatically based on value chossen in cell k1 and choosing data from Column O:R.
Put data validation list in cell G1 based on cell value in K1.

Here i have selected Bi-Weekly and have manually created Data validation list.
If I select Semi-Monthly or Monthly then i have to redo.

Let me know if you have any questions.
Thanks.

Riz

Yes. This is called dependent drop-downs.

Make each of your columns into separate tables, name them, and use the formula =INDIRECT($K$1) for the DV in cell G1.

See attachment.

Try using the following formula in the Source field of the Data Validation:

=INDEX($O$2:$R$34,0,MATCH($K$1,$O$1:$R$1,0))

Hello 63falcon & Root:

Thanks a lot, this will save lots of time

Riz

Glad we could help. Thanks for the rep!