Validation drop down list :: MrExcel Message Board


 FAQFAQ
   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   FavoritesFavorites   StatisticsStatistics 
 RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
Online StoreOnline Store

MrExcel Message Board Forum Index -> Excel Questions

Validation drop down list
Post new topic   Reply to topic
Last Thread | Next Thread  >   Printable version
  Author    Thread

Knight of Nee
Board Regular


Joined: 04 Aug 2003
Posts: 76
Location: England
Flag: England

Status: Offline

 Reply with quote  

Validation drop down list

this is a little difficult to explain so bare with me.... below is a list of players for a team, every team has a number shown in the first colloumn.

Microsoft Excel - PPL_LADIES_FINALV1.0.xls___Running: xl2000 : OS = Windows XP
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
=

A
B
C
D
13
Team NoPlayers NameTeam NamePlayers Phone Number
14
1(No Player)(N/A) 
15
1C PriceSilver Jubliee 
16
2(No Player)(N/A) 
17
2J.AndersonBreaks 
18
3(No Player)(N/A) 
19
3T.EvansWheatsheaf 
20
4(No Player)(N/A) 
21
4S.GibbsStar Inn 
22
5(No Player)(N/A) 
23
5J.MalloySpring 
24
6(No Player)(N/A) 
25
6T.OskarPost Office 
26
7(No Player)(N/A) 
27
7T.GeeCoopers 
28
8(No Player)(N/A) 
29
8J SmithFoxcovert Vixens 
30
9(No Player)(N/A) 
31
9A.HuntOxcart 
32
10(No Player)(N/A) 
33
10B.GibbsPloughmans 
34
11(No Player)(N/A) 
35
11R.SmithThe Court 
36
12(No Player)(N/A) 
37
12T.SmithGolden Lion 
MyPlayers 

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

Post Fri Sep 19, 2003 12:19 pm 
 View user's profile Send private message

Andrew Poulsom
MrExcel MVP


Joined: 22 Jul 2002
Posts: 8266

Flag: Uk

Status: Offline

 Reply with quote  

Re: Validation drop down list

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

Post Fri Sep 19, 2003 12:24 pm 
 View user's profile Send private message

Knight of Nee
Board Regular


Joined: 04 Aug 2003
Posts: 76
Location: England
Flag: England

Status: Offline

 Reply with quote  

Re: Validation drop down list

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

Microsoft Excel - PPL_LADIES_FINALV1.0.xls___Running: xl2000 : OS = Windows XP
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
=

A
B
C
D
E
F
G
H
I
J
K
L
M
2
HomeAwayDateHome TeamResHome PlayerHome ResScoreScoreAway ResAway PlayerAway TeamRes
3
11026/08/2003Silver JublieeL  
 FALSE 
 PloughmansL
4
11026/08/2003Silver Jubliee   
 FALSE 
 Ploughmans 
5
11026/08/2003Silver Jubliee   
 FALSE 
 Ploughmans 
6
11026/08/2003Silver Jubliee   
 FALSE 
 Ploughmans 
7
11026/08/2003Silver Jubliee   
 FALSE 
 Ploughmans 
8
11026/08/2003Silver Jubliee   
 FALSE 
 Ploughmans 
9
11026/08/2003Silver Jubliee   
 FALSE 
 Ploughmans 
MyResults 

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.


Last edited by Knight of Nee on Fri Sep 19, 2003 12:28 pm; edited 1 time in total

Post Fri Sep 19, 2003 12:25 pm 
 View user's profile Send private message

Knight of Nee
Board Regular


Joined: 04 Aug 2003
Posts: 76
Location: England
Flag: England

Status: Offline

 Reply with quote  

Re: Validation drop down list

quote:
Originally posted by Andrew Poulsom:
Are you writing another message to explain the problem? Presently only your worksheet appears.


yeah its there now u beat me to it

Post Fri Sep 19, 2003 12:27 pm 
 View user's profile Send private message

Andrew Poulsom
MrExcel MVP


Joined: 22 Jul 2002
Posts: 8266

Flag: Uk

Status: Offline

 Reply with quote  

Re: Validation drop down list

Have a look here:

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

Post Fri Sep 19, 2003 12:30 pm 
 View user's profile Send private message

Knight of Nee
Board Regular


Joined: 04 Aug 2003
Posts: 76
Location: England
Flag: England

Status: Offline

 Reply with quote  

Re: Validation drop down list

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

Post Fri Sep 19, 2003 1:42 pm 
 View user's profile Send private message

just_jon
MrExcel MVP


Joined: 04 Sep 2002
Posts: 4007
Location: Huntsville AL
Flag: Blank

Status: Offline

 Reply with quote  

Re: Validation drop down list

See if this helps --

Microsoft Excel - Book1___Running: xl2000 : OS = Windows ME
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
=

A
B
C
D
E
F
1
Team #Team NameSilver_JubileeBreaksWheatsheafStar_Inn
2
1Silver_JubileeSJ Player name1Breaks name1Wheat. name1SI name1
3
2BreaksSJ Player name-2Breaks name-2Wheat. name-2SI name-2
4
3WheatsheafSJ Player name-3Breaks name-3Wheat. name-3SI name-3
5
4Star_InnSJ Player name-4Breaks name-4Wheat. name-4SI name-4
6
5SpringSJ Player name-5Breaks name-5Wheat. name-5SI name-5
7
6Post_OfficeSJ Player name-6Breaks name-6Wheat. name-6SI name-6
8
7CoopersSJ Player name-7Breaks name-7Wheat. name-7SI name-7
9
8Foxcovert_VixensSJ Player name-8Breaks name-8Wheat. name-8SI name-8
10
9OxcartSJ Player name-9Breaks name-9Wheat. name-9SI name-9
11
      
12
Using Insert | Name | Define, name the ranges above as:
13
A2:B10 named Teams; C2:C10 named Silver_Jubilee
14
D2:D10 named Breaks; E2:E10 named Wheatsheaf; F2:F10 named Star_Inn
15
Do *not* use spaces in your names, use the "_" character instead
16
      
17
Team #Team NamePlayers   
18
1Silver_JubileeSJ Player name-7In C18, using Data Validation, choose List
19
   & enter:  =INDIRECT($B$18)  in the Source box.
Sheet3 

[HtmlMaker 2.40] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.


You can copy the =INDIRECT($B$18) DATA VALIDATION CELL DOWN AS FAR AS YOU NEED ENTRIES.
_________________
just_jon
Book of the Month: I'm Not Really an MVP, I Just Play One on TV [j. jon, 2004]

Post Fri Sep 19, 2003 2:52 pm 
 View user's profile Send private message

Knight of Nee
Board Regular


Joined: 04 Aug 2003
Posts: 76
Location: England
Flag: England

Status: Offline

 Reply with quote  

Re: Validation drop down list

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

Post Sat Sep 20, 2003 12:08 am 
 View user's profile Send private message

Knight of Nee
Board Regular


Joined: 04 Aug 2003
Posts: 76
Location: England
Flag: England

Status: Offline

 Reply with quote  

Re: Validation drop down list

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

Post Sat Sep 20, 2003 6:27 pm 
 View user's profile Send private message
  Display posts from previous:      

MrExcel Message Board Forum Index -> Excel Questions


Forum Jump:
Jump to:  

Post new topic   Reply to topic
Page 1 of 1



Add To Favorites

 


Forum Rules:
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB: 2.0.4 © 2001 phpBB Group

Need help posting your first question? Read how to post

Need extra help ? Couldn't get the answer you needed ? Get a free quote from our Consulting Team

Download Colo's HTML Maker utility for displaying your Excel Worksheet on the board.

Download VB HTML Maker to post your code on the board


Check out our new index to 485 Excel Articles.


Return to MrExcel Consulting

All contents Copyright 1998-2004 by MrExcel.com
If you believe information posted here is from your copyrighted source, notify us per the Terms of Use
Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.