How to filter the data and highlight the cell?

Joined
Jul 9, 2014
Messages
11
Reaction score
0
Points
0
I have code attached below. the code when run it will populate to sheet 2 and highlight the cell when it meet the condition.
according to year and month.

my situation is to filter the year.

the 'year' and 'month' row will populate manually. in the file, i manually create 2012,2013,2014,2015 and 2016 row and months
the problem is, when user delete any of the year for example 2014, it will only populate the 2012,2013,2015 and 2016 without 2014.
means here, it only populate any year they want.

can you help me?
thanks.
View attachment saver.xlsm
 
Back
Top