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?

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?

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

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