Is there a macro that could change all of my selected cells to a certain selection of a drop down list of the selected cells? --- Meaning all cells selected are drop down lists (the same drop down list) and I want them all to read something else from the list.
I have created a worksheet where I copied a row hundreds of times that contained a drop down list Column B. There are only three options to pick in the drop down list. Now I want to select about 30 of them at once and switch them to the second option in the list or maybe the Third option in the list. Is there a macro that can do this after I select the cells (I have no problem selecting the cells manually, this does not need to be part of the macro)?
If possible this does not even have to be a macro maybe some key stroke combination with the ctrl and shift keys but I have tried and nothing works.
Here is my Data Validation (if it is needed): ='E & L Rate'!$B$3:$D$3
Bookmarks