formula to collapse year recurrence, grantt macro

copy the formula from the formula sheet of the forChart.xls and paste
the formula to the cell next to the first occurence in the
grantt_chart.xlsm table. select the data range and press ALT+F11 to
enter macro mode and then run the macro.