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?
Have you accomplished your goal?
English(K8:R200) and Science (L8:S200) Education are overlapped.
English(K8:R200) and Science (L8:S200) Education are overlapped.