Hide columns based off of dropdown values

S

suptechguy

New Member
Joined
Jan 15, 2020
Messages
10
Office Version
  1. 365
Platform
  1. 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

Team234567891011121314151617Team
AriWasDet@Car@NYJ@dalSeaBYEMiaBuf@SEA@NELAR@nygPhiSF@LARAri
Atl@dalChi@GBCar@MinDet@CarDenBYE@NoLVNO@lacTB@KC@TBAtl
Bal@HouKC@WasCin@PHIPitBYE@Ind@NETen@pitDal@cleJacNYG@CinBal
Car@TB@lacAri@atlChi@NoAtl@KCTBDet@MinBYEDen@GB@WasNOCar
ChiNYG@atlIndTB@Car@LARNO@tenMinBYE@GBDetHou@Min@JacGBChi
Cin@cle@PhiJac@Bal@IndCleTenBYE@pit@WasNYG@MiaDalPit@HouBalCin
CleCinWas@dalInd@pit@CinLVBYEHouPhi@Jac@tenBal@nyg@NYJPitCle
DalAtl@SEACleNYGAri@Was@PhiPitBYE@MinWas@Bal@CinSFPhi@nygDal
Den@pitTB@NYJ@NEMiaKCBYE@atl@LVLACNO@KC@CarBuf@lacLVDen
Det@GB@AriNOBYE@Jac@atlInd@MinWas@CarHou@ChiGB@tenTBMinDet
GBDet@NoAtlBYE@TB@HouMin@SFJac@IndChiPhi@detCarTen@ChiGB
HouBal@pitMinJac@tenGBBYE@Jac@cleNE@detInd@Chi@IndCinTenHou
IndMinNYJ@Chi@cleCinBYE@detBal@tenGBTen@Hou@LVHou@pitJacInd
Jac@tenMia@Cin@HouDetBYE@lacHou@GBPitCle@MinTen@BalChi@IndJac
KC@lac@BalNELV@Buf@DenNYJCarBYE@LV@TBDen@Mia@NoAtlLACKC
LACKCCar@TB@NoNYJ@MiaJacLVBYE@Den@BufNEAtl@LVDen@KCLAC
LAR@Phi@BufNYG@Was@SFChi@MiaBYESea@TBSF@AriNENYJ@SEAAriLAR
LVNO@NEBuf@KCBYETB@cle@lacDenKC@atl@NYJIndLACMia@DenLV
MiaBuf@JacSea@SF@DenLACLAR@AriNYJBYE@NYJCinKCNE@LV@BufMia
Min@IndTen@Hou@SEAAtlBYE@GBDet@ChiDalCarJac@TBChi@No@detMin
NE@SEALV@KCDenBYESF@Buf@NYJBal@HouAri@lac@LAR@MiaBufNYJNE
NO@LVGB@detLACBYECar@Chi@TBSFAtl@Den@atl@PhiKCMin@CarNO
NYG@ChiSF@LAR@dalWas@PhiTB@WasPhiBYE@Cin@SEAAriCle@BalDalNYG
NYJSF@IndDenAri@lacBuf@KCNE@MiaBYEMiaLV@SEA@LARCle@NENYJ
PhiLARCin@SF@pitBalNYGDalBYE@nyg@cleSea@GBNO@Ari@dalWasPhi
PitDenHou@tenPhiCle@BalBYE@dalCin@JacBalWas@Buf@CinInd@clePit
SF@NYJ@nygPhiMiaLAR@NE@SEAGB@NoBYE@LARBufWas@dal@AriSeaSF
SeaNEDal@MiaMinBYE@AriSF@Buf@LARAri@PhiNYGNYJ@WasLAR@SFSea
TBCar@DenLAC@ChiGB@LV@nygNO@CarLARKCBYEMin@atl@detAtlTB
TenJac@MinPitBufHouBYE@CinChiInd@Bal@IndCle@JacDet@GB@HouTen
Was@Ari@cleBalLAR@nygDalBYENYG@detCin@dal@pit@SFSeaCar@PhiWas
Team234567891011121314151617Team
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

gtd526
  • Question Question
Conditional Formatting for Matching Odd Rows only
Replies
4
Views
255
gtd526
gtd526
Emerlin
  • Solved
Formula needed to filter and sort data from range - Excel 2016.
2
Replies
10
Views
398
Peter_SSs
Peter_SSs
gtd526
  • Solved
vba add column before each date listed in row (nba schedule)
Replies
2
Views
372
gtd526
gtd526
gtd526
  • Solved
vba Insert comment for value matches -NFL Teams
Replies
1
Views
334
gtd526
gtd526
gtd526
  • Solved
vba Insert Column and add values to empty cells
Replies
7
Views
471
gtd526
gtd526

Forum statistics

Threads
1,223,911
Messages
6,175,324
Members
452,635
Latest member
laura12345

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top