I'm trying to design a trade checker for an NBA fantasy league I'm in.

I have a list of teams in a range (named "Teams"), a list of players
in each team in a range (named "Players"), and a list of the salaries
for all the players in a range (named "Salaries").

I need to design the trade checker in a way that allows me to pick a
team from a drop-down list (through data validation), and have a
second drop-down automatically populated with the names of the players
of that particular team. Consequently, if I pick a player from the
second drop-down list, I need his salary to automatically pop up in a
cell next to his name. I need to create 3 such "Teams" drop-downs to
allow for the possibility of a 3-way trade.

Finally, when all of this set up, I need Excel to make sure that the
salaries of the players acquired by one team are within 125% +
$100,000 of the salaries they send out.

Is this feasible?

Have a look at this link:

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

which shows how to implement dependent data validation. This should
get you started.

Hope this helps.

Pete

On Oct 23, 2:09 pm, supersub15 wrote:
I'm trying to design a trade checker for an NBA fantasy league I'm in.

I have a list of teams in a range (named "Teams"), a list of players
in each team in a range (named "Players"), and a list of the salaries
for all the players in a range (named "Salaries").

I need to design the trade checker in a way that allows me to pick a
team from a drop-down list (through data validation), and have a
second drop-down automatically populated with the names of the players
of that particular team. Consequently, if I pick a player from the
second drop-down list, I need his salary to automatically pop up in a
cell next to his name. I need to create 3 such "Teams" drop-downs to
allow for the possibility of a 3-way trade.

Finally, when all of this set up, I need Excel to make sure that the
salaries of the players acquired by one team are within 125% +
$100,000 of the salaries they send out.

Is this feasible?

On Oct 23, 9:16 am, Pete_UK wrote:
Have a look at this link:

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

which shows how to implement dependent data validation. This should
get you started.

Hope this helps.

Pete

On Oct 23, 2:09 pm, supersub15 wrote:



I'm trying to design a trade checker for an NBA fantasy league I'm in.

I have a list of teams in a range (named "Teams"), a list of players
in each team in a range (named "Players"), and a list of the salaries
for all the players in a range (named "Salaries").

I need to design the trade checker in a way that allows me to pick a
team from a drop-down list (through data validation), and have a
second drop-down automatically populated with the names of the players
of that particular team. Consequently, if I pick a player from the
second drop-down list, I need his salary to automatically pop up in a
cell next to his name. I need to create 3 such "Teams" drop-downs to
allow for the possibility of a 3-way trade.

Finally, when all of this set up, I need Excel to make sure that the
salaries of the players acquired by one team are within 125% +
$100,000 of the salaries they send out.

Is this feasible?- Hide quoted text -

- Show quoted text -

Thanks. Great source.

You're welcome.

Pete

On Oct 23, 2:27 pm, supersub15 wrote:
On Oct 23, 9:16 am, Pete_UK wrote:





Have a look at this link:

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

which shows how to implement dependent data validation. This should
get you started.

Hope this helps.

Pete

On Oct 23, 2:09 pm, supersub15 wrote:

I'm trying to design a trade checker for an NBA fantasy league I'm in.

I have a list of teams in a range (named "Teams"), a list of players
in each team in a range (named "Players"), and a list of the salaries
for all the players in a range (named "Salaries").

I need to design the trade checker in a way that allows me to pick a
team from a drop-down list (through data validation), and have a
second drop-down automatically populated with the names of the players
of that particular team. Consequently, if I pick a player from the
second drop-down list, I need his salary to automatically pop up in a
cell next to his name. I need to create 3 such "Teams" drop-downs to
allow for the possibility of a 3-way trade.

Finally, when all of this set up, I need Excel to make sure that the
salaries of the players acquired by one team are within 125% +
$100,000 of the salaries they send out.

Is this feasible?- Hide quoted text -

- Show quoted text -

Thanks. Great source.- Hide quoted text -

- Show quoted text -