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.

This file might be a help:
http://www.bygsoftware.com/examples/...d_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"



"Stevie" wrote in message
om...
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.

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

--
Regards
Frank Kabel
Frankfurt, Germany


Stevie wrote:
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.

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)

"Stevie" wrote in message
om...
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.

Hi Bob,

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

Thanks in advance,
Marij

--
Message posted from http://www.ExcelForum.com

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

--
Message posted from http://www.ExcelForum.com

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)

"marijo " wrote in message
...
Bob,

Btw, I forgot to mention that I am using combo box. Is there a way to
link your second drop-down combo box selection based from your first
selection? For example, in the first combo box drop-down, you can
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 show
only countries in EMEA.

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

Hope to hear from you soon.

Thanks,
Marijo


---
Message posted from http://www.ExcelForum.com/

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.

(Stevie) wrote in message . com...
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.

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)

"Stevie" wrote in message
om...
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.

(Stevie) wrote in message
. com...
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.

hi bob

my email add is , 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

--
Message posted from http://www.ExcelForum.com

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)

"marijo " wrote in message
...
hi bob,

my email add is , i'm also interested in the
data validation spreadsheet that you have so i could study this as
well. may i have both spreadsheets (combo box and data validation
versions) ?

thanks so much!
marijo


---
Message posted from http://www.ExcelForum.com/

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.

"Bob Phillips" wrote in message ...
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)

"Stevie" wrote in message
om...
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.

(Stevie) wrote in message
. com...
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.