How to use Loop and If to return value

[caooi23]

Hi,
I need a VBA to return "NA" for column I if it is error, the code used were evaluate and add (show in attachment). And to return value to column J, if I2 = NA then"NA"; I3=0 then "Remain"; I4=-1 then "Improved"; I5=-2 then "Excellent"; I6=1 then "Drop"; I7=2 then "worst". And return value in next cell of column "K", for every row checked as "checked".

Thanks.

[davesexcel]

Try this,

Please Login or Register  to view this content.

[caooi23]

Hi Dave,
Thanks for the help, but it just giving me the result of column H. How if I wanted the result at column J if it is "improve", "remain" or "worst etc in column J, and indicate the line as checked when it run through, as this will be run periodically.
The lines checked, will not be running again in next run. I tried following, but it's only works for column K, as all checked, but no result on column J.

Please Login or Register  to view this content.

[/QUOTE]

[davesexcel]

Try this

Please Login or Register  to view this content.

[caooi23]

Hi Dave,
Thank you for the great help. May the good merits of this works transmit to you.Merry X'mas.