I have year data in column E
In column J, I have dates data. Also in this column some cells are empty and some have pink background.
I want to scan and compare values in row J (dates) to row E (years).
First of all, i want to count the number of each year(col) for empty cells(row J).
Then for the cell with pink background with dates data, If the date in row J falls in the year in E, I want the count to increase by one and count all dates that fall in a particular year.
Then I want to put this result, the count number for year for empty cells, starting from cell H4 and downwards (H5 and so on) and count number for pink cells with dates starting from cell I4 and onward.
Is it possible to do in VBA ?
In column J, I have dates data. Also in this column some cells are empty and some have pink background.
I want to scan and compare values in row J (dates) to row E (years).
First of all, i want to count the number of each year(col) for empty cells(row J).
Then for the cell with pink background with dates data, If the date in row J falls in the year in E, I want the count to increase by one and count all dates that fall in a particular year.
Then I want to put this result, the count number for year for empty cells, starting from cell H4 and downwards (H5 and so on) and count number for pink cells with dates starting from cell I4 and onward.
Is it possible to do in VBA ?
