How do I populate this list

[HotRod]

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?

 

[Tom Ogilvy]

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.

 

[HotRod]

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

 

[Tom Ogilvy]

http://www.google.com/search?hl=en&q=dependent+lists+in+comboboxes&btnG=Google+Search