Forum Discussion
Solved
How do I stop a data validation formula changing when I copy and paste it?
Hi, I have a workbook with two worksheets. In worksheet 1 I have set up a drop-down list using data validation from the list I have created in worksheet 2. The formula for the validation look...
JessColusso You need to make all column and row references absolute, so use $A$2:$A$90 in stead.
JessColusso You need to make all column and row references absolute, so use $A$2:$A$90 in stead.
- Thank you Riny_van_Eekelen that has worked 🙂
