Hello
I have a problem with data validation:
I have a list that is called in the data validation. However I want to change the value in the list (i.e. rename an entry), but the cell that references this list does not update. How can this be achieved?
Also, is there away to have a non-unique list entry? For example, where the list is a catalogue of room names, two cells in the list are called 'office'.Excel seems to just find the first one it comes upon. Can I get it to reference the one I picked from the list?
Thanks very much for any help
Bookmarks