Hide/Show rows based on drop down list

MarvinP

Thank you so Much! That is exactly what I'm trying to do. Now Ill try and adapt that to the file I really need it on in the morning. If I cant get it to work I might be reaching out to you with hat file sometime tomorrow if you don't mind.

Thanks Again!!

Marvin P

Ok in the VBA you have "If Not Intersect(Target, Cells(4, "G")) Is Nothing Then" but in my sheet that Im going to use this on the Cells E41:E42 are Merged and that is where the Data Validation list is located. I have changed the code from If Not Intersect(Target, Cells(4, "G")) Is Nothing Then to If Not Intersect(Target, Range("E41:E42")) Is Nothing Then and cant get it to work. I cant just do If Not Intersect(Target, Range("E:E")) Is Nothing Then Because I will have Validation on column E3 Rows 2, 15 28 Can this still be done?

Here is the sheet so you can see what I'm trying to do.. So if the Data Validation in Cell E41:E42 is Blank it would hide Rows 42:48 but any other selection it would show Rows 42:48. Disregard the conditional formatting Ill fix that once this problem has been fixed LOL

Thanks Again!