S
sumesh56
I would like to get a macro to produce the result sheet out of th
marksheets provided.there are two files. one is marksheet. second one i
result sheet .based upon col-A-of the marksheet,slno, it should produc
the result sheet of induvidual student as per the format shown in th
sheet named result sheet.
there should be option for asking the user"how many result sheet do yo
want? from records---- to----- records. where in the input will be th
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 t
say that the macro should not have any connection with the result shee
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 th
student BLISTON.
the user should get the freedom to change the order of the subjects i
the result sheet
+-------------------------------------------------------------------
|Filename: TEST RESULTSHEET 020414.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=966
+-------------------------------------------------------------------
marksheets provided.there are two files. one is marksheet. second one i
result sheet .based upon col-A-of the marksheet,slno, it should produc
the result sheet of induvidual student as per the format shown in th
sheet named result sheet.
there should be option for asking the user"how many result sheet do yo
want? from records---- to----- records. where in the input will be th
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 t
say that the macro should not have any connection with the result shee
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 th
student BLISTON.
the user should get the freedom to change the order of the subjects i
the result sheet
+-------------------------------------------------------------------
|Filename: TEST RESULTSHEET 020414.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=966
+-------------------------------------------------------------------