I have a VBA code wherein I want the VBA code the take data based on month
Code
Sheets("Apr").Range("B9").Formula = "=SUMPRODUCT(--(data!R6C5:R" & lngEndRow & "C5=RC1)*(data!R6C2:R" & lngEndRow & "C2=R6C)*(MONTH(data!R5C1:R" & lngEndRow & "=4),data!R6C7:R" & lngEndRow & "C7)"
I want the VBA code to pick up values for all amount entered in April
As I have different sheets for all months based on the changes in the VBA code I would proceed further for all months.