Greetings everyone! I have been struggling for a day now to create two codes. The first code is to add a team member to a list, and the second code is to add a lesson while keeping all formatting and updating formulas visible on photos. I am wondering if VBA is too complex to achieve this. Can anyone offer assistance? Thank you.
Functions :
13 )=COUNTIF(D12:D12, ">=3")
14)=COUNTIF(E12:E12, ">=3")
15)=D14-D13
16)=IF(COUNTIF(E12:E12, "<>")>0, D13/COUNTA(D12:D12), 0)
17)=D14/COUNTA(E12:E12)
Coll:
H)=SUMPRODUCT((MOD(COLUMN(D12:E12)-COLUMN(D12),2)=0)*(D12:E12>=3))
I)=SUMPRODUCT((MOD(COLUMN(D12:E12)-COLUMN(E12),2)=0)*(D12:E12>=3))
J)=I12-H12
k)=SUMPRODUCT((MOD(COLUMN(D12:E12)-COLUMN(D12),2)=0)*(D12:E12>=3))/I12
L)=I12/26
Functions :
13 )=COUNTIF(D12:D12, ">=3")
14)=COUNTIF(E12:E12, ">=3")
15)=D14-D13
16)=IF(COUNTIF(E12:E12, "<>")>0, D13/COUNTA(D12:D12), 0)
17)=D14/COUNTA(E12:E12)
Coll:
H)=SUMPRODUCT((MOD(COLUMN(D12:E12)-COLUMN(D12),2)=0)*(D12:E12>=3))
I)=SUMPRODUCT((MOD(COLUMN(D12:E12)-COLUMN(E12),2)=0)*(D12:E12>=3))
J)=I12-H12
k)=SUMPRODUCT((MOD(COLUMN(D12:E12)-COLUMN(D12),2)=0)*(D12:E12>=3))/I12
L)=I12/26