Linking dropdowns

[Stevie]

Hi all,

I'm not sure whether it's possible, but I decided to ask it here
anyway.
I want to thank you in advance for any useful help. If it isn't
possible, just say so.

I created two dropdowns in separate columns using Data > Validation.
I would want to link them in a dynamic way, i.e. I want to let the
input of the second dropdown, vary depending on the value that's
chosen from the first dropdown.

Boys > John, Paul, Simon
Girls > Anita, Linda, Sarah.

Boys in the first dropdown should give the boys names, and girls the
second row.
I wonder if there is a limit to the input range, for the real workbook
contains much more data than this little example.

Before I forget it, I'm working in a nt 4.0 environment with Office
2000.
There will be a migration to XP soon, so if it isn't possible yet in
Office 2000, but it is in XP, just tell me as well.

 

[Andy Wiggins]

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/validation_and_indirect.zip
It's in the "Worksheet (No VBA)" section on page:
http://www.bygsoftware.com/examples/examples.htm

Shows how using "Data > Validation" and "INDIRECT()" you can populate a cell
from two dependant lists


--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

 

[Frank Kabel]

Hi
also see: http://www.contextures.com/xlDataVal02.html

 

[Bob Phillips]

Stevie,

I have a sample workbook that is already setup to do this. ALl you need to
do is to plug in your data.

Want a copy?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[marijo]

Hi Bob,

I have a similar problem as Stevie.
May I have a copy of the your sample workbook?

Thanks in advance,
Marij

 

[marijo]

Bob,

Btw, I forgot to mention that I am using combo box. Is there a way t
link your second drop-down combo box selection based from your firs
selection? For example, in the first combo box drop-down, you ca
select the continent you belong to such as: Asia, EMEA, Americas, etc.
then if you chose EMEA, the second combo box drop-down list will sho
only countries in EMEA.

P.S. I'm using excel windows 97.

Hope to hear from you soon.

Thanks,
Marij

 

[Bob Phillips]

Marijo,

I have a combobox version which you can have, but I need an email address
as Excelforum masks it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Stevie]

Hi Bob,

First of all, thanks for your quick reply.
I wondered if it is possible to specify more than two different ranges.

If so, could you send me a copy of this absolutely fabulous workbook.

Stevie.

 

[Bob Phillips]

HI Stevie,

It is on it's way. Not sure whether you wanted the Data Validation or the
Combobox version, so I sent both.

It is set-up for 3 drop-downs, but can be extended for as many as you want,
although nit might get cumbersome as the rows and the DDs increase.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[marijo]

hi bob

my email add is (e-mail address removed), i'm also interested in th
data validation spreadsheet that you have so i could study this a
well. may i have both spreadsheets (combo box and data validatio
versions)

thanks so much
marij

 

[Bob Phillips]

Marijo,

I have posted them to you.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Stevie]

Bob,(and anybody with useful help)

I wondered if it were possible to put multiple rows one beneath
eachother and however get for every single row the possibility to
choose dynamically.

As far as I can see, it's impossible.

Thanks in advance,

Stevie.