Hide/Show rows based on drop down list

First of all THANK you to all of you!! You have helped me many times throughout the years and just want to say Thanks!! Now my problem. Have been seaching here and the web and cant get much to work at what Im doing. I have tried Form Control and Active X Drop downs and Combo Boxes and cant get anything to work.

What Im trying to do is if something is selected from the drop down it would then hide Rows 20:26 but if any other name is selected I would like it to unhide those rows 20:26. I have tried multiple VBA and can never get it to unhide or change with the drop down I always have to enter the number in the cell myself and the vba's work. I have attached an example.

Using Excel 2010

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!

First off thanks for getting back to me.
I will rework it and take out the merged cells out then I will start debugging if necessary after that . If I do need you after that I will reach out to you thanks again for the direction !

QUOTE=MarvinP;4629612]Hi,

First, get rid of all those Merged Cells. It may look cool but you don't know what cell the data is going to be entered into.

Then look how to debug your code by setting a breakpoint and stepping through it.

http://www.cpearson.com/Excel/DebuggingVBA.aspx

If that doesn't work and you need more, let me know..[/QUOTE]