Hi all
I have workbook with data in sheet(result)
sheet(result).range(F1) have value like: yyyymm=> 201909, 201908 ....
Now I want macro to check that:
1. Get 02 character from right(range(F1)) = b
2. If b <> 12 then check each cell(1,j).value from range(G1, last column)
- If cell(1,j).value =...