I am shoked to hear from boss that I have to publish the project on monday.
i need your help urgently....
I was working with details of students with their questionire. I have done the scoring of one qestionire and did the sorting according to the total score. That was the task assigned to me. it is working well except that i didnt get a vba code for summation.
but now the situation changed.
there are7 different questionaire in which all students should fill questionaire 3. that means every questionaire is attached with Q-3. Now what I did that I totalled the q-3 score and say questionaire 1 score and sorted according to the total. But the problem is that every student can answer any number of questionaire. so if one student answered q-1 and q2 , there will be a repetition of q-3 in each questionaire. so i want to avoid that. if I have done q-3 once and if it will come again, it should add the total of q-3 automatically without asking the same inputbox stuff that used in q-3.
i can identify the questions of questionire 3 only with its heading , like 'question 10'.
how can i do that.
i am attaching a sheet of the sample.
i have done scoring with macors and vba.
my doubt is : if i did the scoring of questionaire 1 , i will do the scoring of q-3. then if i am doing the scoring of questionare 2, it should check the student is done the questionare 1 and if so, the scoring of q-3 should do automatically.
can i get a result at the earliest.
thanks a lot