Hello,

I would assume this is pretty simple... What I need is when I paste this into multiple cells that the cells in this date validtion also change. Currently I have to do it manually for each line. It copies the data validation as is unlike a formula which adjusts to the cells that its being pasted in.

My formula's

=IF($C$3="",Regions,NA)
=IF($B$3="",NA,INDIRECT($B$3))

Example of the next cell and so on

=IF($C$4="",Regions,NA)
=IF($B$4="",NA,INDIRECT($B$4))

Thanks for the help!