How to project data from 1 sheet to another but remove columns with no data below header.

[johnmpc]

Hi All,

I have an input sheet for placing clothing orders. I then have a separate output sheet that displays the data in a way i can copy and paste what is needed to send back out.

I have Small medium large Xlarge XXlarge sizes in column headers, but what i want is if any columns below the header are empty i don't want to display the column or header.

Is that possible?

 

[Joe4]

That is a new question, and therefore should be posted to a new thread.