Lists

Hi, I have a problem I need help with. I will attempt to explain what I am
trying to do. I have created a drop down box with several customer's names
to choose from. Each customer has different "unit" numbers to choose from.
What I am wanting to do is when I select a customer, I want the next drop
down list to show only that customer's "units". Basically, I want two drop
down lists beside each other. When I select a customer, then that customer's
units are shown. When I select a different customer in the first box, then
the unit numbers change to the customer they are assigned to. As I stated
before, I know how to make a the drop box listing the customers, so I do not
need help making the drop boxes.

Thank you in advance for your help!

See this:

http://contextures.com/xlDataVal02.html

--
Biff
Microsoft Excel MVP


"Varney" wrote in message
...
Hi, I have a problem I need help with. I will attempt to explain what I
am
trying to do. I have created a drop down box with several customer's
names
to choose from. Each customer has different "unit" numbers to choose
from.
What I am wanting to do is when I select a customer, I want the next drop
down list to show only that customer's "units". Basically, I want two
drop
down lists beside each other. When I select a customer, then that
customer's
units are shown. When I select a different customer in the first box,
then
the unit numbers change to the customer they are assigned to. As I stated
before, I know how to make a the drop box listing the customers, so I do
not
need help making the drop boxes.

Thank you in advance for your help!

That worked like a charm. You are the man!!!

"T. Valko" wrote:

See this:

http://contextures.com/xlDataVal02.html

--
Biff
Microsoft Excel MVP


"Varney" wrote in message
...
Hi, I have a problem I need help with. I will attempt to explain what I
am
trying to do. I have created a drop down box with several customer's
names
to choose from. Each customer has different "unit" numbers to choose
from.
What I am wanting to do is when I select a customer, I want the next drop
down list to show only that customer's "units". Basically, I want two
drop
down lists beside each other. When I select a customer, then that
customer's
units are shown. When I select a different customer in the first box,
then
the unit numbers change to the customer they are assigned to. As I stated
before, I know how to make a the drop box listing the customers, so I do
not
need help making the drop boxes.

Thank you in advance for your help!

Now, another problem. Once my customer, then unit are selected, is there a
function that automatically fills in the information for that particular unit?

"Varney" wrote:

Hi, I have a problem I need help with. I will attempt to explain what I am
trying to do. I have created a drop down box with several customer's names
to choose from. Each customer has different "unit" numbers to choose from.
What I am wanting to do is when I select a customer, I want the next drop
down list to show only that customer's "units". Basically, I want two drop
down lists beside each other. When I select a customer, then that customer's
units are shown. When I select a different customer in the first box, then
the unit numbers change to the customer they are assigned to. As I stated
before, I know how to make a the drop box listing the customers, so I do not
need help making the drop boxes.

Thank you in advance for your help!

Same website:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Varney" wrote in message
...
Now, another problem. Once my customer, then unit are selected, is there
a
function that automatically fills in the information for that particular
unit?

"Varney" wrote:

Hi, I have a problem I need help with. I will attempt to explain what I
am
trying to do. I have created a drop down box with several customer's
names
to choose from. Each customer has different "unit" numbers to choose
from.
What I am wanting to do is when I select a customer, I want the next drop
down list to show only that customer's "units". Basically, I want two
drop
down lists beside each other. When I select a customer, then that
customer's
units are shown. When I select a different customer in the first box,
then
the unit numbers change to the customer they are assigned to. As I
stated
before, I know how to make a the drop box listing the customers, so I do
not
need help making the drop boxes.

Thank you in advance for your help!