Need help filtering a table with a Macro

Hello,

I am trying to filter the table bellow for all ROOM's that have No's across columns D-G. I have tried using the macro below but couldn't get it to work:

Please Login or Register  to view this content.

Please help, i need to get this figured out by 7am!!! Thanks a ton!! If you guys have an easier way of making sure all my data will be there with a different filtering method please advise. My actually spread sheet is much larger than the picture below. Ive tried using the filter selction across the rows but it will not keep on my no entries and will filter out some.

Table:
Filtering Question.png

Ok got it done, thanks! Is maybe an advanced filtering method a good way? I really would like to know a macro for this but anything will do for now!