Forum Discussion
Solved
VBA, LINK MULTIPLE ROWS IN A SHEET TO RANGE OF CELLS IN ANOTHER SHEET
Hello distinguished excel experts. I have a worksheet, say (sheet1) containing 200 students with names in column (b8:b200) and scores in each subject (e.g Mathematics range, say (C8:J200), English(K8...
Don't afraid. We are not asking your data. I just need your column name headers in which column (no need of student names and their scores).
(i.e.) You saying putting your 200 student names in range (b8:b200) but it is 193 students only. coz you did not specified (b1:b7) containing student details.
1.Column A contains what? if it is students roll no. i don't need them for result.
1.a. Rows 1 to 7 contains what? coz some header may helpful to find result easily.
2. You are saying "Mathematics (C8:J200), English(K8:R200), Science (L8:S200), Education (T8:AA200)".
But tell us upto which cell reference your subjects going.
3. While displaying result what you want, only student name and total score of all subjects (or) subject wise total?
Thanks for your response. I need to send the entire workbook for better clarification but it cannot be sent here. Its 15mb document.
I need another network to send it. Can someone help please?
I need another network to send it. Can someone help please?
Thank you for your response. My concern is actually to have the problem solved not the fair of sharing my data. Sorry if my expression seemed so.
To give a clearer view, I have sent parts of the workbook showing 2 broadsheets: one for 1st term and the other for 3rd term. The one 1st term will serve the second term. I can handle that if the code to find the first term is given.
ABOUT THE ENTIRE PROJECT
The project is the system for designing report sheet for students in Nursery 1 and 2 and Primary 1 - 6.. It comprises of worksheets for broadsheets of each class and only 4 worksheets for report sheets. I.e. one report for each of:
1) 1st term and 2nd term Nursery
2) 1st term and 2nd term Primary
3) 3rd term Nursery and
4) 3rd term Primary
I need codes to send the results of students to these sheets after the class and term to be printed is selected.
Please I prefer VBA codes not lookups formula because I can understand codes easily.
Sorry, my English is not good enough to express myself better. I attached 4 worksheets for better understanding.
Again, thank you very much for your readiness to help.
To give a clearer view, I have sent parts of the workbook showing 2 broadsheets: one for 1st term and the other for 3rd term. The one 1st term will serve the second term. I can handle that if the code to find the first term is given.
ABOUT THE ENTIRE PROJECT
The project is the system for designing report sheet for students in Nursery 1 and 2 and Primary 1 - 6.. It comprises of worksheets for broadsheets of each class and only 4 worksheets for report sheets. I.e. one report for each of:
1) 1st term and 2nd term Nursery
2) 1st term and 2nd term Primary
3) 3rd term Nursery and
4) 3rd term Primary
I need codes to send the results of students to these sheets after the class and term to be printed is selected.
Please I prefer VBA codes not lookups formula because I can understand codes easily.
Sorry, my English is not good enough to express myself better. I attached 4 worksheets for better understanding.
Again, thank you very much for your readiness to help.