Hi guys,
Here is screenshot of case: Image View - TIS
Two matrix: "bits" and "adj's %".
"Bits": is derivative of input data above.
E.x. (if choosed andrew and feb) than "1" appears in appropriate cell in matrix "adj's".
So the issue is: using vba make formulae like "if 1 in some cell in second matrix -> input in appropriate cell in matrix above (they are iderntical) value of % (in this ex is 10%).
I cant use formulae due to the neccesary of save previous result in "adj's" matrix. If use formulaes the will dissapear.
Here is screenshot of case: Image View - TIS
Two matrix: "bits" and "adj's %".
"Bits": is derivative of input data above.
E.x. (if choosed andrew and feb) than "1" appears in appropriate cell in matrix "adj's".
So the issue is: using vba make formulae like "if 1 in some cell in second matrix -> input in appropriate cell in matrix above (they are iderntical) value of % (in this ex is 10%).
I cant use formulae due to the neccesary of save previous result in "adj's" matrix. If use formulaes the will dissapear.