Delete certain rows based on value in another cell

hi ^^

okay so am creating a template with a lot of catergoies and fill in spots for each one. But for each form filled out not all caterogies are need so some would be Not applicable, hhowever their are still the spaces and rows below the catoergies that I want to delete. So I turned one cell into a dropdown box where it's either blank or Not applicable. If its blank its find all the cells below stay because we are using the catoergy. If it's Nto applicable I want to delete the following 4 or 5 cells beneth the catoergy heading. If this possible.

**note I already have a auto fit code in place so am adding on to it :

Please Login or Register  to view this content.

the NOTA is the cells that ae montiored to see if it is blank or NotApplicable. orginially I was using a macro but I couldnt get it to delete the right number of cells in the right place..Help and thxs in advance.

Do you have a sample file that you can upload?