Hi there,
I am in need of some help with drop-down lists. I am trying to create a bracket in excel.
I have my first section complete, but am having trouble limiting the options for the next rounds.
For example, for the first section I have four options for each cell (2 total).
Let's say the first cell has: Team1, Team2, Team3, Team4. The second cell has TeamA, TeamB, TeamC, TeamD.
What I am trying to do is that when 1 team from each cell is selected (for example, Team1 and TeamA), I am trying to create a new drop-down list where the only options will be Team1 and TeamA.
I have tried simply selecting the two original cells (the ones with 4 values in each cell) as the source but am getting an error.
Any help is appreciated,
Thanks
Bookmarks