How do I populate this list
 

I've already started google searching but wondering if someone can direct me
to examples that are a little more specific.

On worksheet 1 I have

Parent Last Name, Parent First Name, Child Last Name, Child First Name


On Worksheet2 I want to create a dropdown list in Column C, D, E (preferable
a list that autocomplete as you type) so that as the last name of all
available Parent Lastnames is in List1 and all possible Parent FirstNames is
in List2, once I know the parent I want List3 to contain all of the children
that parent has registered.

1) Is there a way to do this in excel or should I be looking at VBA samples?
2) Am I looking at using recordsets or do I need to loop through all
entries?
3) Is it possible for me to use SQL Select in VBA or excel?

How do I populate this list
 

Look at Debra Dalgleish's site for dependent lists in Data validation:

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

Questions 2 and/or 3
would be pertinent to VBA and a different solution. Of course you can use
activeX controls and use VBA to loop or use SQL select using ADO.

--
Regards,
Tom Ogilvy

"HotRod" wrote in message
...
I've already started google searching but wondering if someone can direct
me
to examples that are a little more specific.

On worksheet 1 I have

Parent Last Name, Parent First Name, Child Last Name, Child First Name


On Worksheet2 I want to create a dropdown list in Column C, D, E
(preferable
a list that autocomplete as you type) so that as the last name of all
available Parent Lastnames is in List1 and all possible Parent FirstNames
is
in List2, once I know the parent I want List3 to contain all of the
children
that parent has registered.

1) Is there a way to do this in excel or should I be looking at VBA
samples?
2) Am I looking at using recordsets or do I need to loop through all
entries?
3) Is it possible for me to use SQL Select in VBA or excel?

How do I populate this list
 

Just to help me out what should I be Googling for? What terms?

I've already been able to link several dependancy lists together but this
won't accomplish everything I want, are there any other ways of populating a
list?

Should I use VBA to re-populate this list every time the cell losses focus?
I have a feeling that this would be way to slow. THANKS

How do I populate this list
 

http://www.google.com/search?hl=en&q... Google+Search

--
Regards,
Tom Ogilvy

"HotRod" wrote in message
...
Just to help me out what should I be Googling for? What terms?

I've already been able to link several dependancy lists together but this
won't accomplish everything I want, are there any other ways of populating
a
list?

Should I use VBA to re-populate this list every time the cell losses
focus?
I have a feeling that this would be way to slow. THANKS