Hello
I would like help in converting if function into VBA code.
So, first I want to use 2 sheets in my excel for the code, first ActiveSheet, which needs to receive data from Sheet10 or ("Whole info") sheet.
Ok so there are 4 if functions:
ActiveSheet B22=IF('Whole info'!N2>0,50%,0%),
ActiveSheet B23=IF('Whole info'!M2>0,10%,0%),
ActiveSheet B24=IF(OR('Whole info'!J2>0,'Whole info'!K2>0),10%,0%),
ActiveSheet B25=IF('Whole info'!L2>0,10%,0%)
I hope you can help me convert this in code.
Thanks in advance
I would like help in converting if function into VBA code.
So, first I want to use 2 sheets in my excel for the code, first ActiveSheet, which needs to receive data from Sheet10 or ("Whole info") sheet.
Ok so there are 4 if functions:
ActiveSheet B22=IF('Whole info'!N2>0,50%,0%),
ActiveSheet B23=IF('Whole info'!M2>0,10%,0%),
ActiveSheet B24=IF(OR('Whole info'!J2>0,'Whole info'!K2>0),10%,0%),
ActiveSheet B25=IF('Whole info'!L2>0,10%,0%)
I hope you can help me convert this in code.
Thanks in advance