Hide certain rows based on drop box selection

Hello,

I've viewed many posted and still can't get one right. I've attached the spreadsheet I'm working on. I need to hide corresponding rows based on D2 (drop box) selection.

Example: Select - Plastic Laminate Cabinets = show rows 3-18 and hide all others.

I've indicated the rows effected by each cabinet selection. Note: Do not hide D2.

Any help would be most apprciated.

I know nothing about with VBA...........

See attached - it should get you started

Cheers
SAE

Originally Posted by seckert

See attached - it should get you started

Cheers
SAE

Perfect!!! Thank you for the help.