MS Excel data validation list only works on static data lists. How can I use this feature on a dynamic list?
Don C asked: I would like to see the drop-down data validation list expand with new entries or contract after entries are deleted from the range. Is this possible?