I created Drop-Down lists with data validation which by condition end up setting the values of the cells next to them.
For example, C2 has 3 values in a drop down list, and depending on the value or chosen option for C2, D2 is modified.
The problem is that when I filter a list that has drop down lists in it. D2 can be changed to D10, D29, etc, depending on the filter. The problem is the drop down list stays in C2. What I need is for the drop down list to move with the whole rown when it is moved in filtering. Is there a way to do this?
Thanks in advance
Kusac
Bookmarks