Hello,
There is a drop-down data validation list which takes the data from source cells on the second sheet. The list is used to show the group a word belongs to and is used for every word. However if I decide to change the name of a group, I change it on the second sheet and the old name remains on the first page until I manually choose the new title from the drop down list. Is there a way for this update to happen automatically? I will be grateful for any ideas on the subject.
Bookmarks