Excel list question

[puforee]

On my spread sheet I have two cells next to each other...one contains Location information....the other, to the right, is a dropdown that selects Remote or Local. This is already set up.

What I need is for the location cell to be changed to a Dropdown list that is variable based on the result of the Remote/Local Drop down.

So, if Remote is selected...the location dropdown list will show the selections just for Remote.

If local is selected...the location dropdown list will show the selections just for local.

Help!

 

[SkipVought]

Hi,

You might check in this site, as there is an example using fruit, I believe -- Select RED and Red fruit is in the second drop down, etc...

http://www.contextures.com/tiptech.html

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[puforee]

Thanks SkipVought

There are a lot of links on that page. You wouldn't happen to know which one I should use...do you?

 

[SkipVought]

Data Validation - Dependent Dropdown


Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[puforee]

Thanks,

Got it and it is what I need. :-D :-D