Summarizing columns, hiding certain cells

[LegionLord]

I have a huge worksheet that shows all customers and every item we pack. I need to print a copy that does not include columns where nothing was ordered (row 426 from column E:BT contain the column total).

Is there a macro I can use that would hide columns, print, and unhide columns or would it be better to use VBA to not show columns with a "0" on row 426? If VBA is used, how would you "turn it of" if you needed to modify the sheet?

Thanks in advance for helping figure this out.

Copy of V Sales List Forum.xlsm

[jaslake]

Hi LegionLord

Here is Code to Hide Columns with 0 in the Last Row

Please Login or Register  to view this content.

And here's Code to UnHide all Columns

Please Login or Register  to view this content.

Assign the Code to Buttons on the Target Sheet.