Option button to hide rows

I need a little help here as I am trying something new, and am not sure how to proceed.
I am trying to change from 2 columns to 3 columns where there are a few variables. This is the original:

Please Login or Register  to view this content.

This works fine as it simply hides the rows that have no value.
I need to make this with columns 4 5 and 6, and all 3 are variable, so that if I hide column 4, 5 and 6 are visible, and only the empty cells from these 2 columns will be hidden and i want to hide and row that has no value, but if one or the other has a value (x) then it must remain visible.
Does anyone know a macro that I can use for this?
Kinda stuck and have no real idea how to make it work.

Thanks

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I will add them this time only, uture posts may be locked if you don't follow the Rules

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Your table layout will cuse problems. I suggest you remove the Merged Cells, then for AutoFilter to work correctly the data should have a header row above the data. It's not clear to Excel which Row is the header row.

Is this what you need?

Please Login or Register  to view this content.

The code that I posted will only filter each individual. Are you clearing the Filter before continuing?

Do you mean that all 3 columns need to be empty for each row?

Try this

Please Login or Register  to view this content.