how to get the resultsheet from the markslips
 

I would like to get a macro to produce the result sheet out of the marksheets provided.there are two files. one is marksheet. second one is result sheet .based upon col-A-of the marksheet,slno, it should produce the result sheet of induvidual student as per the format shown in the sheet named result sheet.
there should be option for asking the user"how many result sheet do you want? from records---- to----- records. where in the input will be the sl nos in col -A.
the second file named "result sheet" is only for illustration purpose. after a look at it , pls delete it and then prepare the macro.I want to say that the macro should not have any connection with the result sheet in this attachment.
if the macro asks
how many result sheet do you want?
then if the input is
from records 7 to 7

(if i ask for record no.7),then it should give result sheet of the student BLISTON.


the user should get the freedom to change the order of the subjects in the result sheet.