Thread: Data Validation cell entry - How to paste like formula's do?

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!

Too simple, thanks! I copied the fomula and adapted it for me so I wasnt sure why those were needed.