Hide Empty Column

[Former Member]

Hi All,

I have scenario where I need to hide the empty column in my report.

Column 1, Column 2, Column 3

If we don't have data in column 3 it should not display in report. Expansion on column is based on the data. empty column shouldn't display.

best way to achieve this... VBA ?

Please advise

Thank you

Neil

[Former Member · Accepted solution]

Assuming the report/schedule is using the SheetOptions.  If so, enable the option to

Remove or Hide Columns.

[Former Member · Accepted solution]

Thank you - I have tried that already my issue is in my report I am doing look up from data sheet --

If in data sheet we have data for column 1   No Data column 2 and Col  3 then 

First block of report would show which include Col 1, Col 2, Col 3-- 

If no data in Col 1, 2, and 3 then don't show up.

Col 1,      Col 2,        Col 3                                Col 4               Col 5,        Col 6

Product 1, Product 2, (Total local member )   Product 1 and Product 2 ( Total Local member)

Brand1 -         Brand 1                                     Brand 2,          Brand 2 ----  

Any ideas - Please advise

Thank you

Neil

[former_member186338 · Accepted solution]

Sorry, but unclear! Can you provide a screenshot?