Hi I have been struggling trying to create this code for the last two weeks and am hoping someone can help me .
I want to copy the value (Date) and pastespecial as a result of a formula.
For instance I have formula in B2 which is IF(B3="","",IF(B3>=80%,TODAY(),"")) as soon as the result of the formula shows today's date I want it to automatically copy the value into B4, in C2 formula IF(c3="","",IF(c3>=80%,TODAY(),"")) as soon as the result shows today's date I want it to automatically copy the value into c4, in d2 formula IF(d3="","",IF(d3>=80%,TODAY(),"")) as soon as the result shows today's date I want it to automatically copy the value into d4 , etc for e, f, and g.
Hoping that someone will be able to help me on this as I really been struggling trying to get this to work.
Thank you in advance for anybody's help on this.
Regard.
KO
I want to copy the value (Date) and pastespecial as a result of a formula.
For instance I have formula in B2 which is IF(B3="","",IF(B3>=80%,TODAY(),"")) as soon as the result of the formula shows today's date I want it to automatically copy the value into B4, in C2 formula IF(c3="","",IF(c3>=80%,TODAY(),"")) as soon as the result shows today's date I want it to automatically copy the value into c4, in d2 formula IF(d3="","",IF(d3>=80%,TODAY(),"")) as soon as the result shows today's date I want it to automatically copy the value into d4 , etc for e, f, and g.
Hoping that someone will be able to help me on this as I really been struggling trying to get this to work.
Thank you in advance for anybody's help on this.
Regard.
KO