Hi I need to create drop down list. When I chose the name of the site. It should bring up the list. Please help me. Thank you.
Hi I need to create drop down list. When I chose the name of the site. It should bring up the list. Please help me. Thank you.
First of all, you need to create your list of countries, as follows:
country
England
France
India
Spain
UAE
Suppose this is in column H of the Data sheet, starting with H1, then you can set this up as a named range by selecting those cells including the header and click on Formulas | Create from Selection and then clicking OK.
Then in C2 of the other sheet you can click on Data | Data Validation and choose List on the panel and put in this formula:
=country
and then you have your drop-down from which you can select the appropriate country.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks