Dynamic Columns? (this time with example)

[andy3919]

I am trying to create dynamic columns on a report tab, based on pre-defined filter sorts. The issue is I cannot figure out how to automatically change the headings and number of columns.

See example.

Thank you in advance.

[Alf]

You could try adding these lines to your "Blond" macro:

Please Login or Register  to view this content.

For macros "Age" and "State" you just modify which columns to delete and which should be "Autofit".

If you don't wish to add the headings to your report use

Please Login or Register  to view this content.

Alf

[andy3919]

Thank you Alf. I am trying the code.