VBA/Macro Print selected columns in a table

[shannonBrewHub]

Hi all,

I have a table that I would like to be able to set up a print button to print only certain columns. As the seasons change we change the fruit we supply. and when I type YES in above the fruit, all the calculations auto generate the pick lists.

So I would like to only print out the columns 2, 3, 4, 5, 6, 7 and then from columns 9 - 17 only if they have data in them.
I can then have another Macro that does columns 2, 3, 4, 5, 6, 7 and 18 for the Bananas

I hope this is possible, Or if there is another way I am all ears.

 

[steve the fish]

Hidden columns wont print so hide the ones you dont require. Its not clear to me how you decide which you want to print.