Hide/Unhide Rows based on Criteria

[Phillycheese5]

Hi,
I have a file is set up with a list of expenses down column A and different time periods in columns B to M. I want to display a consolidated report by hiding rows when there is a zero for a particular expense in all periods. I have a validation in column N that will show a "1" if that condition exists. I'd like to create a button that does this called "hide empty" and also a button that is called "show all" which will show all rows.
Any guidance would be appreciated.
Thanks,
Phillycheese

[TMS]

Ideally, you should post a sample workbook so that we can see what you want to do and what you are working with.

If all the rows that meet the condition (all zero in period) have a 1 in the cell/column, you should be able to use AutoFilter to hide/unhide the rows.

Record macros while you hide the rows and unhide the rows and then assign those macros to your command buttons.

Regards

[Phillycheese5]

TMShucks,
Thanks for the response. I'm attaching the file I'm trying to test. Also, it's worth noting that in the actual file, the numbers that populate the expenses pull in from an external source and those numbers will change based on which division I run the report for (I'll be using this for about 20 different divisions). So the rows that get hidden will depend on the results.
Hope this clarifies what I'm looking for.
I appreciate the help,
Phillycheese

[TMS]

Sample workbook updated as described.

Regards

[Phillycheese5]

Works great, thank you.

[TMS]

You're welcome. Thanks for the feedback.