Hi.
I have a number of columns C to AZ that contain customer names.
Then Rows 3 to 145 that contain products they order. The Total number of products are summed in column B
Not all customers order every day and they do not order all products.
I need a Toggle tab that hides and unhides all columns from C to AZ that do not contain any data in that column and also hides the rows that has a zero in the B Column.
So from the below Columns C-E-G-H-I will hide and Rows 3 and 4.
Thanks
Bookmarks