right answer has value 1,wrong answer has value 0

Hi everybody,

I have answer sheets with 4 choices.But I need to change right answer to 1 and the rest wrong answer to 0.

with sample- I want to change page 1 to page 2 in this sample

page1 to page2.xlsx

Thank you Special-K .it works but it takes time.I have limited time and I need to change 900 sheets.Can anyone produce a macro?

Originally Posted by Special-K

Edited update

in Sayfa!A2
=INT((ROW()-1)/4)+1
and copy down the column for 400 rows

in Sayfa2!B2
=CHAR(65+MOD(ROW()-2,4))
and copy down for each row

try it

Please Login or Register  to view this content.

hi nilem.thank your for your help.it is exactly what I need.can your rearrange the macro for 5 choices.NEW.xlsx

Please Login or Register  to view this content.

Please Login or Register  to view this content.