Limiting Entries in A List Box

D

Dave C

I'm using a list box so the user can select the player name when entering
team members on a score sheet (sheet 1). The list box range is connected to
the Player Details (sheet 2) and displays all players irrespective of the
team they play for. Using the team name (sheet 1) I want to limit the
players shown in the list box to only those of that team. Sheet 2 contains a
list of the players with a unique player number, their name and the team they
are on.

I'd be grateful to receive suggestions as to whether this is possible and if
it is, how to achieve it.

Thanks,

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif until a number occurs four times in a row then return that number 3
A better way than nested IF? 3
Populating entire rows of data from a master sheet? 3
vlookup and validation lists 1
Using vlookup on a validation list 0
macro or worksheet function? 3
Create a summary list without using PivotTables? 8
How select an item in a list box 1

Top