Column E contains year data.
While column J contains some dates and some cells are empty in this column.
I want to look in column J and count the number of each year (there are many years in column E) for all the cells for which cells in row J are empty.
Then I want to scan the range from column H to column K to find the same years (a table that I am creating) and put the count number two cells (2nd adjacent column) that contains the same year value.
Can anybody help me with the VBA code ?
While column J contains some dates and some cells are empty in this column.
I want to look in column J and count the number of each year (there are many years in column E) for all the cells for which cells in row J are empty.
Then I want to scan the range from column H to column K to find the same years (a table that I am creating) and put the count number two cells (2nd adjacent column) that contains the same year value.
Can anybody help me with the VBA code ?
