group/ungroup columns in budget based on current reporting month

[ajm]

Hi folks, I am working with columns of data set out like a budget. it has each month of the current financial year across the top. the report currently groups the future months that have no data yet. I would like to set up a worksheet change event that does the grouping for me when I change the date in a particular field. Any ideas?

 

[ajm]

possible solution I just read about. if the month at the top of the column is greater than the current month, make the column width zero. that would do the same thing, I think.