Hi,

How can I create a dynamic list of values based on the value selected from
other cell. For example, I have a list countries on cell A1, and list of
Cities in cell B1. City list should be changed based on the value selected in
Country list. Is it possible in Excel ? I tried looking on onClick or
onChange events or some ting, but I couldn't find any. Any help on this
regard, is much appreciated.

Sounds like you want dependent lists. See this:

http://contextures.com/xlDataVal02.html

--
Biff
Microsoft Excel MVP


"VV" wrote in message
...
Hi,

How can I create a dynamic list of values based on the value selected from
other cell. For example, I have a list countries on cell A1, and list of
Cities in cell B1. City list should be changed based on the value selected
in
Country list. Is it possible in Excel ? I tried looking on onClick or
onChange events or some ting, but I couldn't find any. Any help on this
regard, is much appreciated.

Hi,

Here are the steps for creating a dynamic data validation list:

1. Create three or more list in the spreadsheet. For example:
A B C
New York Quebec Canada
Seattle Toronto US
Miami Victoria

You would name lists: US (A1:A3), Canada (B1:B3), Countries (C1:C2) this
last is optional

2. Select the cell where you want the initial validation list, for this
example, D1
3. Choose Data, Validation
4. From the Allow drop-down and choose List
5. In the Source box enter the following formula
=Countries
6. Move to the location where you want the dynamic (changing) list to
appear, say for example E1
7. Choose Data, Validation, List and in the Source box enter the formula
=INDIRECT(D1)

You can also make a self-referential dynamic data validation list.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"VV" wrote:

Hi,

How can I create a dynamic list of values based on the value selected from
other cell. For example, I have a list countries on cell A1, and list of
Cities in cell B1. City list should be changed based on the value selected in
Country list. Is it possible in Excel ? I tried looking on onClick or
onChange events or some ting, but I couldn't find any. Any help on this
regard, is much appreciated.