Solved: Code for vba to replace below formula

[VISHAL120]

Hi ok i have understand the way you have program.

i have included another sheet on the data files2 where this one also i am using the formula sumif like this:
shadow_k_mins!AG2-SUMIF(shadow_k_mins!$R$35:$R$1544,shadow_k_mins!$AD2,shadow_k_mins!AG$35:AG $1544)
and after that i used vba to copy and paste as values. you can click on the button still to load minutes to see the calculation.

This one will calculate the still to plan minutes which later i used to convert to operators after the planning system has already plan the produce mins on the shadow_k_mins.

but still this one as you see will limit and will take times to run.

can you please help on that as i have been trying to used the same programming logic you used for the shadow_k_mins calculation but till now its not working.

many thanks for your help.