Spreadsheet: 544740d1509015228-how-to-shows-cells-range-depending-on-dropdown-menu-value-how-to-shows-cells-range-depending-on-dropdown-menu-value
Sheet: test

2017-06-01 00:00:00 | 2017-06-05 00:00:00 | ab | c | d | e | ab | c | d | e | ab | c | d | e | ab | c | d | e | ab | c | ab | ab | ab | c | d | e | select a trip start date | *
 |  | ab | c | d | e | ab | c | d | e | ab | c | d | e | ab | c | d | e | ab | c | ab | ab | ab | c | d | e
 |  | ab | c | d | e | ab | c | d | e | ab | c | d | e | ab | c | d | e | ab | c | ab | ab | ab | c | d | e
 |  | ab | c | d | e | ab | c | d | e | ab | c | d | e | ab | c | d | e | ab | c | ab | ab | ab | c | d | e |  |  | https://www.excelforum.com/excel-general/1206202-how-to-shows-cells-range-depending-on-dropdown-menu-value.html
 |  | ab | c | d | e | ab | c | d | e | ab | c | d | e | ab | c | d | e | ab | c | ab | ab | ab | c | d | e |  | *
 |  | ab | c | d | e | ab | c | d | e | ab | c | d | e | ab | c | d | e | ab | c | ab | ab | ab | c | d | e |  | 2017-06-01 00:00:00
 |  | ab | c | d | e | ab | c | d | e | ab | c | d | e | ab | c | d | e | ab | c | ab | ab | ab | c | d | e |  | 2017-11-06 00:00:00
 |  | ab | c | d | e | ab | c | d | e | ab | c | d | e | ab | c | d | e | ab | c | ab | ab | ab | c | d | e |  | 2017-11-16 00:00:00
 |  | ab | c | d | e | ab | c | d | e | ab | c | d | e | ab | c | d | e | ab | c | ab | ab | ab | c | d | e
2017-09-04 00:00:00 | 2017-09-08 00:00:00 | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h
 |  | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h
 |  | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h
 |  | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h
 |  | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h
 |  | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h
 |  | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h
 |  | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h
 |  | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h | x | g | t | h
2017-11-06 00:00:00 | 2017-11-10 00:00:00 | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef
 |  | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef
 |  | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef
 |  | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef
 |  | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef
 |  | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef
 |  | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef
 |  | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef
 |  | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef | fd | gr | tr | ef
2017-11-16 00:00:00 | 2017-11-20 00:00:00 | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r
 |  | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r
 |  | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r
 |  | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r
 |  | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r
 |  | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r
 |  | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r
 |  | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r
 |  | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r | q | w | e | r