I have a worksheet in which different fields are using different data validation lists. User will go and make selections for the various fields.
I want to have a reset macro which will reset the all the different fields to a specific choice in datalists.
I tried recording a macro. went to each field and selected the choice in list..It doesnot work..
Any insight will be helpful