Hi, I have searched the forum but could not find any similar post on this issue and hoped that someone could help.
I need to input or choose an address when a data from a drop down list has been selected.
For Example, I have countries like China, US-A (must be in this way as this is our code), Japan and Singapore. And upon selecting China, I have serveral cities to choose from and for the case if I selected Singapore, instead of a drop down selection showing only Singapore, can the field display only the result as there is only 1 selection and no other options. This is important as most of the account has only 1 address and only less than 10% has multiple addresses.
I had used Dynamic range for the Cities but am stuck with this code "US-A" as we have been using the "-" for the past 10 over years and am unable to change it and the Dynamic range cannot be named with "-".
My next query is, how to make the drop down list on A2 to show only the Countries listed in column F and when I have more countries added, I need not update the Data Validation source on A2 to show more fields, which in my sample file, the drop down list for the countires have many blanks below, which should stopped at Singapore as it was the last country on the list. If Thailand is to be added into column F, A2 last country should show till Thailand without changing the Data Validation source (Ideally).
Thank you.
Bookmarks