Hello,
I can't figure out how to refresh data in a cell with a dropdown list when the source list change.
Say I have a drop down list with 4 options: Phase 1, Phase 2, Remediation and Year End. The user selects Phase 1. In the source list, Phase 1 is changed to Phase 4. I don't know why, but Excel does not refresh the users choice and where it had Phase 1 now read Phase 4.
I have attached an example. Any help is really appreciated.
Bookmarks