Course selection

[taniab]

So we have a list of all students and their course selections.
there are five main "pathways" they can choose and then they select 6 courses.

There student ID is listed and then True in any ONE of the pathways
Untitled Spreadsheet

ATAR

General

VIPGen

ViIPFound

Profile

then after that will be listed "true" for each of their course selections

I want another table with formulas or a macro, that will list
the first student
The pathway code that has True Selected against it
Course selection 1 (the first one that has "True"
Course selection 2
Course Selection 3
Course selection 4
Course Selection 5
Course selection 6

Then the next student record on the next row


So essentially it looks at each colum, asks if there is a "true" in it, if there is it lists the name of the colum and then moves tot he next colum. If no "True" it skips and checks the next colum until it reaches the end of the row.

 

[onlyadrafter]

Hello,

Does this work as expected?

Sub COURSE_TABLE()
    Application.ScreenUpdating = False
    With Sheets("Sheet1")
        For MY_ROWS = 2 To .Range("A" & Rows.Count).End(xlUp).Row
            MY_STUDENT = .Range("A" & MY_ROWS).Value
            Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1).Value = MY_STUDENT
            For MY_COLS = 3 To .Cells(1, Columns.Count).End(xlToLeft).Column
                If .Cells(MY_ROWS, MY_COLS).Value = True Then
                    MY_COURSE = .Cells(1, MY_COLS).Value
                    Sheets("Sheet2").Range("IV" & Range("A" & Rows.Count).End(xlUp).Row).End(xlToLeft).Offset(0, 1).Value = MY_COURSE
                End If
            Next MY_COLS
        Next MY_ROWS
    End With
    Application.ScreenUpdating = True
End Sub

You will need to change sheet references, to your tab names.

 

[Peter_SSs]

@taniab

I suggest that you

• update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
• investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.