Hello all! I am a new user to the board, so I really appreciate anyone who takes the time to look into this. I haven't been able to get a response from any Excel Gurus, which is why I am trying this forum.
Link to pictures of my spreadsheet to help visually represent my question: http://i.imgur.com/aGC00XA.png
What I currently have:
If Existing Client is selected from the first dropdown list of {Prospect, Existing Client}, a second dropdown list provides multiple options to choose from a predefined list {AA,AB,AC,BA,BB,BC,CA,CB,CC}. See Picture 1. Alternatively, if Prospect is selected, the dropdown list only allows the user to select "N/A" from the dropdown list. See Picture 2.
What I want:
When Prospect is selected, I want the cell to automatically fill with "N/A" so the user doesn't have to select it from the dropdown list. Currently, the user has the option to select "N/A" from the dropdown list, but I would prefer that it automatically fill.
I'd be happy to upload my spreadsheet somewhere as well if that would help at all!
Thanks!
Bookmarks