Hello,
I can't figure out how to change an existing drop down menu in one of the company's spreadsheets. The menu contains a list of initials. When the initials are picked the cell value is changed to a number. The number is then matched with a numbered list on another sheet for more specific information.
I want to know how drop down menus can set cells equal to a different but corresponding value. Also, how can I change the setup or list on an existing drop down menu.
Thanks,
Eric
Bookmarks