Hello,
I have a various cells that uses a drop down list via data validation from a separate set of cells 'List'.
When I I update any of the cells in my 'List', for example "Apple" changed to "Apples", the cell(s) referencing 'List' does not automatically update.
Is there a way for excel to make these changes to all cells that use the drop down 'List' instead of manually going through the drop down? In my case, this would means 100s of additional 'clicks' to the spreadsheet.
I need to protect my sheet so, find and replace won't work.
Thanks in advance!
I have a various cells that uses a drop down list via data validation from a separate set of cells 'List'.
When I I update any of the cells in my 'List', for example "Apple" changed to "Apples", the cell(s) referencing 'List' does not automatically update.
Is there a way for excel to make these changes to all cells that use the drop down 'List' instead of manually going through the drop down? In my case, this would means 100s of additional 'clicks' to the spreadsheet.
I need to protect my sheet so, find and replace won't work.
Thanks in advance!