I have a spreadsheet where a particular group of cells has defined drop down values to choose from, using data validation rules to get the list from a seperate sheet.
How do I update all of the cells using this validation to use a new formula? (when changing the sheet/cells where possible values are stored)
To explain further; I have a document where some cells are validating w.r.t. a group of values in another sheet. When copying this 1st sheet to another file, I lose the validation that pulls info from sheet #2. Now, in this particular case the cells were all in one column - so I could select multiple and change data validation to refer to a different set of addresses.
However, what if the validating cells were scattered throughout a sheet, and I wasn't aware of their locations? Hence, what I am asking is given a particular validation, how could I update it in all cells that refer to it (of if this is not possible)