Hi Experts,
I need to following steps in my WB via VBA.
01.
On Button click analyze
if C29=”High” then
+1 @ Cell B48 & D48 & F48 & H48
02.
Find C22 Value from Range C2:C10 (+ or – 3 point leverage)
if True then find respective factor in range B39:B47 & Add +1 else nothing next step
03.
Find C23 Value in Range C2:C10(+ or – 3 point leverage)
if true then find respective factor in range D39:D47 & Add +1else nothing next step
04.
Find C22 value from range G2:G10(+ or – 3 point leverage)
if true then find respective factor in range F39:F47 & Add +1 else nothing next step
05.
Find C23 value from range G2:G10(+ or – 3 point leverage)
if true then find respective factor in range H39:H47 & Add +1 else nothing. End
Find attached file
Thanks
Scoring-G.xlsm
gowflow