Macro to hide and show rows

[delexcel]

Hi there,

I am looking to develop a macro attached to a button for a rostering tool.

When the button is clicked, the macro needs to consider whether there are any hours rostered (indicated by a numerical value in column C) OR whether there has been a manual override (a "Yes" in column A).

If there are no hours rostered (blank col-C) and there has been no manual override (blank col-A), then the row is to be hidden.

Clicking the button again will unhide any hidden rows.

If any more information is required please let me know.

Thank you in advance to those that respond.

 

[delexcel]

Hoping one of the pros out there will have a solution for this...

 

[delexcel]

No one able to help on this?