Help in VBA Code how to calculate coloums by month

[JawaharPrem]

Hi All,

Please help on this code.
i have a date in "J coloum" if Previous Month Ex "dec" data should be calculate from
"C to I", and updated in k coloum.

if current Month Ex "jan" data should be calculate from
"D to I", and updated in k coloum.

i enclosed sample file for your reference.

Thanks
Jawahar Prem

 

[AlanSidman]

Here is a formula solution. VBA is not necessary. =IF(MONTH(J2)=12,SUM(C2:I2),SUM(D2:I2)) and copy down.

 

[JawaharPrem]

Hi,

thanks for your timeits working.