suptechguy
New Member
- Joined
- Jan 15, 2020
- Messages
- 10
- Office Version
- 365
- Platform
- Windows
I am trying to create a spreadsheet that will allow me to use drop down list of values to select a team name. When a team has been selected in the drop down, I would like the corresponding row to hide. So each column is going to have its own drop down. I would like to be able to accomplish this with VBA if possible but it is what it is.
Any ideas? I'm pasting my data below. I couldn't figure out how to upload the file
Any ideas? I'm pasting my data below. I couldn't figure out how to upload the file
Team | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | Team |
Ari | Was | Det | @Car | @NYJ | @dal | Sea | BYE | Mia | Buf | @SEA | @NE | LAR | @nyg | Phi | SF | @LAR | Ari |
Atl | @dal | Chi | @GB | Car | @Min | Det | @Car | Den | BYE | @No | LV | NO | @lac | TB | @KC | @TB | Atl |
Bal | @Hou | KC | @Was | Cin | @PHI | Pit | BYE | @Ind | @NE | Ten | @pit | Dal | @cle | Jac | NYG | @Cin | Bal |
Car | @TB | @lac | Ari | @atl | Chi | @No | Atl | @KC | TB | Det | @Min | BYE | Den | @GB | @Was | NO | Car |
Chi | NYG | @atl | Ind | TB | @Car | @LAR | NO | @ten | Min | BYE | @GB | Det | Hou | @Min | @Jac | GB | Chi |
Cin | @cle | @Phi | Jac | @Bal | @Ind | Cle | Ten | BYE | @pit | @Was | NYG | @Mia | Dal | Pit | @Hou | Bal | Cin |
Cle | Cin | Was | @dal | Ind | @pit | @Cin | LV | BYE | Hou | Phi | @Jac | @ten | Bal | @nyg | @NYJ | Pit | Cle |
Dal | Atl | @SEA | Cle | NYG | Ari | @Was | @Phi | Pit | BYE | @Min | Was | @Bal | @Cin | SF | Phi | @nyg | Dal |
Den | @pit | TB | @NYJ | @NE | Mia | KC | BYE | @atl | @LV | LAC | NO | @KC | @Car | Buf | @lac | LV | Den |
Det | @GB | @Ari | NO | BYE | @Jac | @atl | Ind | @Min | Was | @Car | Hou | @Chi | GB | @ten | TB | Min | Det |
GB | Det | @No | Atl | BYE | @TB | @Hou | Min | @SF | Jac | @Ind | Chi | Phi | @det | Car | Ten | @Chi | GB |
Hou | Bal | @pit | Min | Jac | @ten | GB | BYE | @Jac | @cle | NE | @det | Ind | @Chi | @Ind | Cin | Ten | Hou |
Ind | Min | NYJ | @Chi | @cle | Cin | BYE | @det | Bal | @ten | GB | Ten | @Hou | @LV | Hou | @pit | Jac | Ind |
Jac | @ten | Mia | @Cin | @Hou | Det | BYE | @lac | Hou | @GB | Pit | Cle | @Min | Ten | @Bal | Chi | @Ind | Jac |
KC | @lac | @Bal | NE | LV | @Buf | @Den | NYJ | Car | BYE | @LV | @TB | Den | @Mia | @No | Atl | LAC | KC |
LAC | KC | Car | @TB | @No | NYJ | @Mia | Jac | LV | BYE | @Den | @Buf | NE | Atl | @LV | Den | @KC | LAC |
LAR | @Phi | @Buf | NYG | @Was | @SF | Chi | @Mia | BYE | Sea | @TB | SF | @Ari | NE | NYJ | @SEA | Ari | LAR |
LV | NO | @NE | Buf | @KC | BYE | TB | @cle | @lac | Den | KC | @atl | @NYJ | Ind | LAC | Mia | @Den | LV |
Mia | Buf | @Jac | Sea | @SF | @Den | LAC | LAR | @Ari | NYJ | BYE | @NYJ | Cin | KC | NE | @LV | @Buf | Mia |
Min | @Ind | Ten | @Hou | @SEA | Atl | BYE | @GB | Det | @Chi | Dal | Car | Jac | @TB | Chi | @No | @det | Min |
NE | @SEA | LV | @KC | Den | BYE | SF | @Buf | @NYJ | Bal | @Hou | Ari | @lac | @LAR | @Mia | Buf | NYJ | NE |
NO | @LV | GB | @det | LAC | BYE | Car | @Chi | @TB | SF | Atl | @Den | @atl | @Phi | KC | Min | @Car | NO |
NYG | @Chi | SF | @LAR | @dal | Was | @Phi | TB | @Was | Phi | BYE | @Cin | @SEA | Ari | Cle | @Bal | Dal | NYG |
NYJ | SF | @Ind | Den | Ari | @lac | Buf | @KC | NE | @Mia | BYE | Mia | LV | @SEA | @LAR | Cle | @NE | NYJ |
Phi | LAR | Cin | @SF | @pit | Bal | NYG | Dal | BYE | @nyg | @cle | Sea | @GB | NO | @Ari | @dal | Was | Phi |
Pit | Den | Hou | @ten | Phi | Cle | @Bal | BYE | @dal | Cin | @Jac | Bal | Was | @Buf | @Cin | Ind | @cle | Pit |
SF | @NYJ | @nyg | Phi | Mia | LAR | @NE | @SEA | GB | @No | BYE | @LAR | Buf | Was | @dal | @Ari | Sea | SF |
Sea | NE | Dal | @Mia | Min | BYE | @Ari | SF | @Buf | @LAR | Ari | @Phi | NYG | NYJ | @Was | LAR | @SF | Sea |
TB | Car | @Den | LAC | @Chi | GB | @LV | @nyg | NO | @Car | LAR | KC | BYE | Min | @atl | @det | Atl | TB |
Ten | Jac | @Min | Pit | Buf | Hou | BYE | @Cin | Chi | Ind | @Bal | @Ind | Cle | @Jac | Det | @GB | @Hou | Ten |
Was | @Ari | @cle | Bal | LAR | @nyg | Dal | BYE | NYG | @det | Cin | @dal | @pit | @SF | Sea | Car | @Phi | Was |
Team | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | Team |