Hello,

I have the data validation lists in the excel sheet. i am trying to auto refresh them to the first value upon changing a target.address, Could someone help m eon this please..

Thanks