hide row with drop down value
 

hello,

i need help with the code for this project, the way it should work is when you select the drop down list in 'B5' and select 'dragline' row 91-153 will hide and row 7-90 should remain unhidden, keeping only the rows described as dragline in the B column. same goes for 'shovel, aux, dragline NP' by hiding all but which ever is selected in B5.

need the same for drop down list in 'E5' 'F5' 'G5''K5' 'L5' 'M5'

Any question let me know thanks