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
Bookmarks