Validation drop down list

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Sep 19, 2003

• #2

Are you writing another message to explain the problem? Presently only your worksheet appears.

 

Upvote 0

Knight of Nee

Board Regular

Joined

Aug 4, 2003

Messages

124

• Sep 19, 2003

• #3

no this is a different tab, what i want to happen is when the user enters the team number in the first and second collunm. there will be a drop down list of all team members for that particular team in the home player and away player respectivly. (see below example)

there are 12 teams with varying numbers of players thanks

PPL_LADIES_FINALV1.0.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M
2	Home	Away	Date	HomeTeam	Res	HomePlayer	HomeRes	Score	Score	AwayRes	AwayPlayer	AwayTeam	Res
3	1	10	26/08/2003	SilverJubliee	L				FALSE			Ploughmans	L
4	1	10	26/08/2003	SilverJubliee					FALSE			Ploughmans
5	1	10	26/08/2003	SilverJubliee					FALSE			Ploughmans
6	1	10	26/08/2003	SilverJubliee					FALSE			Ploughmans
7	1	10	26/08/2003	SilverJubliee					FALSE			Ploughmans
8	1	10	26/08/2003	SilverJubliee					FALSE			Ploughmans
9	1	10	26/08/2003	SilverJubliee					FALSE			Ploughmans
MyResults

 

Upvote 0

Knight of Nee

Board Regular

Joined

Aug 4, 2003

Messages

124

• Sep 19, 2003

• #4

Andrew Poulsom said:

Are you writing another message to explain the problem? Presently only your worksheet appears.

Click to expand...

yeah its there now u beat me to it

 

Upvote 0

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Sep 19, 2003

• #5

Have a look here:

http://216.92.17.166/board2/viewtopic.php?t=53213

 

Upvote 0

Knight of Nee

Board Regular

Joined

Aug 4, 2003

Messages

124

• Sep 19, 2003

• #6

hi

i do understand the example but its not of a simlar setup to my spreadsheet and im unsure how to adapt it, could anyone help?

thanks
Craig

 

Upvote 0

just_jon

Legend

Joined

Sep 3, 2002

Messages

10,473

• Sep 19, 2003

• #7

See if this helps --

Book1
	A	B	C	D	E	F
1	Team#	TeamName	Silver_Jubilee	Breaks	Wheatsheaf	Star_Inn
2	1	Silver_Jubilee	SJPlayername1	Breaksname1	Wheat.name1	SIname1
3	2	Breaks	SJPlayername-2	Breaksname-2	Wheat.name-2	SIname-2
4	3	Wheatsheaf	SJPlayername-3	Breaksname-3	Wheat.name-3	SIname-3
5	4	Star_Inn	SJPlayername-4	Breaksname-4	Wheat.name-4	SIname-4
6	5	Spring	SJPlayername-5	Breaksname-5	Wheat.name-5	SIname-5
7	6	Post_Office	SJPlayername-6	Breaksname-6	Wheat.name-6	SIname-6
8	7	Coopers	SJPlayername-7	Breaksname-7	Wheat.name-7	SIname-7
9	8	Foxcovert_Vixens	SJPlayername-8	Breaksname-8	Wheat.name-8	SIname-8
10	9	Oxcart	SJPlayername-9	Breaksname-9	Wheat.name-9	SIname-9
11
12	UsingInsert|Name|Define,nametherangesaboveas:
13	A2:B10namedTeams;C2:C10namedSilver_Jubilee
14	D2:D10namedBreaks;E2:E10namedWheatsheaf;F2:F10namedStar_Inn
15	Do*not*usespacesinyournames,usethe"_"characterinstead
16
17	Team#	TeamName	Players
18	1	Silver_Jubilee	SJPlayername-7	InC18,usingDataValidation,chooseList
19				&enter:=INDIRECT($B$18)intheSourcebox.
Sheet3

You can copy the =INDIRECT($B$18) DATA VALIDATION CELL DOWN AS FAR AS YOU NEED ENTRIES.

 

Upvote 0

Knight of Nee

Board Regular

Joined

Aug 4, 2003

Messages

124

• Sep 19, 2003

• #8

is there a way of doing it without re-hashing myspreadsheet, e.g. using my existing setup but adapting the example in prevoius posts?

 

Upvote 0

Knight of Nee

Board Regular

Joined

Aug 4, 2003

Messages

124

• Sep 20, 2003

• #9

i only ask because i have another sheet which works of the players names and if they are moved around then it will no longer work

 

Upvote 0