validation list or combo box dependant on cell value

[Richard Edwards]

Am i able to determine the values shown in either a validation list or combo
box being dependant on a value in another cell?

ie: Cell A1 = BOB then validation or combo box would then base it's list
from the named range (or whatever the solution may be) based on Bob.
if i was to change A1 to ROY then it would also change the underlying list?

I have tried everything that i think SHOULD work but that it pretty
limited...

thanks in advance

rich

 

[Dave Peterson]

I'd start with Debra Dalgleish's site:
http://contextures.com/xlDataVal02.html

 

[Eduardo]

Hi Richard,
Take a look to Debra Web

http://www.contextures.com/xlDataVal02.html#TwoWord

If this was helpful please say yes. thank you

 

[Stefi]

Make a Google search with "dynamic validation list"! You'll find many
solutions and tutorials!

Regards,
Stefi

„Richard Edwards†ezt írta:

 

[Richard Edwards]

spot on thanks vm!

I'd start with Debra Dalgleish's site:
http://contextures.com/xlDataVal02.html