kshitij_dch
Active Member
- Joined
- Apr 1, 2012
- Messages
- 362
- Office Version
- 365
- 2016
- 2007
- Platform
- Windows
Hello Team ,
I am working on a file where I have 2 Drop Down List in Cell C4 and C5 Respectively
C4 user has 2 options to select ( Win , Loose)
C5 user has 2 options to select ( Make / Wake)
I am struggling to hide rows based on user selection , lets say
If user selects "Win" in C4 and "Make" in C5 than
I want to hide rows ( 4:10 ) and ( 12: 15)
and if user selects "Loose" in C4 and "Make" in C5 than
I want to hide rows (15:17) and (12:15)
Can i do it with VBA??
I am working on a file where I have 2 Drop Down List in Cell C4 and C5 Respectively
C4 user has 2 options to select ( Win , Loose)
C5 user has 2 options to select ( Make / Wake)
I am struggling to hide rows based on user selection , lets say
If user selects "Win" in C4 and "Make" in C5 than
I want to hide rows ( 4:10 ) and ( 12: 15)
and if user selects "Loose" in C4 and "Make" in C5 than
I want to hide rows (15:17) and (12:15)
Can i do it with VBA??