Data Validation with Changing Values
 

I'm working on setting up a NFL Playoff Bracket and want to use Data
Validation to make in cell drop downs. I've made another sheet with all of
the teams and named the ranges for the 1st four games. The issue I am having
is setting up the next drop down list - This is because one team exists and
the other "selected" team will play in the next round. BUT there is the
comparision of seeds as to which team plays which...

How do I make the pseudo combo box show the apporiate team for a user to
select? Ideas? Thanks

Data Validation with Changing Values
 

So, in other words, you have week1, which has all team names
Week 2, you have a drop-down with the two teams from that particular
bracket, and you select the winner?
So in week 3, you want to have the drop down only show the two teams that
were in week 2's bracket?
sounds like you'd just need the data list show as = to the two teams you
pick from the dropdown list for week 2.
Does that make sense?
Not sure if that's how you currently have it set up...

"Steven M. Britton" wrote:

I'm working on setting up a NFL Playoff Bracket and want to use Data
Validation to make in cell drop downs. I've made another sheet with all of
the teams and named the ranges for the 1st four games. The issue I am having
is setting up the next drop down list - This is because one team exists and
the other "selected" team will play in the next round. BUT there is the
comparision of seeds as to which team plays which...

How do I make the pseudo combo box show the apporiate team for a user to
select? Ideas? Thanks

Data Validation with Changing Values
 

That is correct, but where I am at a loss it I am having all the games
entered into ONE spreadsheet. So when the 1st entry picks the teams and I
send the data to a list on another sheet and reference that back in the next
column the 2nd entry is limited to those teams. I need it to specific to
each row of the sheet.



"Sean Timmons" wrote:

So, in other words, you have week1, which has all team names
Week 2, you have a drop-down with the two teams from that particular
bracket, and you select the winner?
So in week 3, you want to have the drop down only show the two teams that
were in week 2's bracket?
sounds like you'd just need the data list show as = to the two teams you
pick from the dropdown list for week 2.
Does that make sense?
Not sure if that's how you currently have it set up...

"Steven M. Britton" wrote:

I'm working on setting up a NFL Playoff Bracket and want to use Data
Validation to make in cell drop downs. I've made another sheet with all of
the teams and named the ranges for the 1st four games. The issue I am having
is setting up the next drop down list - This is because one team exists and
the other "selected" team will play in the next round. BUT there is the
comparision of seeds as to which team plays which...

How do I make the pseudo combo box show the apporiate team for a user to
select? Ideas? Thanks