Lists
 

I would like to stack lists, ie by chioosing a selection in one list it
selects another list of Items I can choose from.

example:
Bob
Chores
Grocery
To Do
Tom
Kids Birthdays
CD Collection
Rock
Metal
Jazz
Etc....
Jeff
Programs
Activities

If in one cell I choose Tom, in the next cell I would like to choose from
the sublist of Tom. Also say I chosen 'CD Collection' below Tom, I would like
the next cell to have the sublist shown under that.

Any ideas on where to find this info if its even possible in excell 2003

Lists
 

I think the best place to start would be Data Validation at
Debra Dalgleish's site http://www.contextures.com/tiptech.html

--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Maytag Man" <Maytag wrote in message ...
I would like to stack lists, ie by chioosing a selection in one list it
selects another list of Items I can choose from.

example:
Bob
Chores
Grocery
To Do
Tom
Kids Birthdays
CD Collection
Rock
Metal
Jazz
Etc....
Jeff
Programs
Activities

If in one cell I choose Tom, in the next cell I would like to choose from
the sublist of Tom. Also say I chosen 'CD Collection' below Tom, I would like
the next cell to have the sublist shown under that.

Any ideas on where to find this info if its even possible in excell 2003

Lists
 

This will get you started:

http://contextures.com/xlDataVal02.html

Biff

"Maytag Man" <Maytag wrote in message
...
I would like to stack lists, ie by chioosing a selection in one list it
selects another list of Items I can choose from.

example:
Bob
Chores
Grocery
To Do
Tom
Kids Birthdays
CD Collection
Rock
Metal
Jazz
Etc....
Jeff
Programs
Activities

If in one cell I choose Tom, in the next cell I would like to choose from
the sublist of Tom. Also say I chosen 'CD Collection' below Tom, I would
like
the next cell to have the sublist shown under that.

Any ideas on where to find this info if its even possible in excell 2003