There are instructions here for dependent data validation lists:

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



Andrew wrote:
i have a sheet with a list of Teams and poeple in each team. Each team has
7 bowlers, but only 5 can compete in one line-up in any order

On my current sheet i want to have a list box to show the bowlers in a
particular team. The team name will change therefor i need the list to
change to correspond with the team name.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html