separate questions and answers of a test

[zeroist]

I want to separate questions and choices of a test.little sample of file is
http://studyenglishgrammar.net/test.xlsx

[zeroist]

Don Guillett in google group advice the formula below.but it did not work on my sheet.can anyone improve it.

Please Login or Register  to view this content.

[watersev]

hi, zeroist, please check attachment, press Run button

[zeroist]

great work.thank you very much. but what if we have 5 choices.
can you again check the new file
test_.xlsm

[watersev]

please check attachment

[zeroist]

it has been working fine till that file.

there has to be 10 rows for 10 question but there 11 rows

10th row has an error

test2.xlsm

[zeroist]

and also for big files as

test1.xlsx

[watersev]

please check attachment, it would be very hard to achieve error free result with that type of unpredictable database data though it can be minimized, I joined both files into one.

[zeroist]

for that file,questions are ok but choices gave error
choices problem.xlsm

please check attachment, it would be very hard to achieve error free result with that type of unpredictable database data though it can be minimized, I joined both files into one.

[Cutter]

@ zeroist

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

[zeroist]

Hi Cutter, I noticed it. I Will use code tags next time

[watersev]

please check attachment

[zeroist]

within 100 questions only one question gave error.I attached that question
one question.xlsm

[watersev]

that's where you will have to correct error manually I'm affraid

[zeroist]

dear watersev ,
I will use this macro for a long time.I am afraid next time I will have more errors.so that I want to have a more developed macro.I want to have what excel can give me.if this is what excel exactly give me,that means this is end.but I belive excel can do more.
Thank you very much who contribute this macro and more.