Hello, I searched around a lot and could not find an answer to this:
I need to replace values in a cell with a macro while keeping the "Data Validation"/ List drop down the same. Is this possible? Each time I tried to use a macro to make the cell value "", it took away the data validation.
Would much appreciate help on this!