How to hide and Unhide rows in a excel sheet based on criteria in multiple columns

[Venkata Ramanaji]

Hello

I just want to know the process of hiding and unhiding rows based on a criteria in multiple columns.

I have attached an excel sheet with the scenario.

Regards
Ramana

 

[Belleke]

based on a criteria

You didn't mention the criteria.
I guess they have to be hidden when both sales (column D & E) are empty.
See example, is this what you want?

 

[Venkata Ramanaji]

You didn't mention the criteria.
I guess they have to be hidden when both sales (column D & E) are empty.
See example, is this what you want?

Hello

It is working.

Thank you very much.

Regards
Ramana

 

[Belleke]

Welcome, glad to help

 

[Venkata Ramanaji]

Welcome, glad to help

Could you pls help me without the click boxes

 

[Belleke]

Like this?

 

[Venkata Ramanaji]

Like this?

Hello

Yes,

Thank you.

Regards
Ramana