Is there a way to get the entry from a dropdown list to apply to multple
cells? All the selected cells have the same list set in their validation
rules, but simply selecting many cells and picking from the list in one does
not work.