Forum Discussion
VBA, LINK MULTIPLE ROWS IN A SHEET TO RANGE OF CELLS IN ANOTHER SHEET
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?
Give sample workbook or screenshot, i'll give codes as you expected.
coz, i can't able to get your need, and input is not clear.
Please my guru, I need to send the entire workbook to you but it is heavy and cannot be sent here, about 15mb