Summarise table based on value

[Daroh]

Hi, I have a table, names of people in column (A) and names of tests in columns B to Y. Each person can only do specific tests which is marked by the name of the test under the heading. If the person cannot do the test this cell is left blank. Is there a way I can select a specific person's name and get a summary (list format) of the tests they can do? Below is an example of I currently have. John can only do test 3 which is marked under test 3 by the name of the test. I have used a table slicer. However, due to the length of the table this is not a viable option.

Names	Test 1	Test 2	Test 3	Test 4	Test 5
John			Test 3
Peter	Test 1		Test 3	Test 4
Mary		Test 2	Test 3		Test 5
Bob	Test 1		Test 3
Mark		Test 2	Test 3	Test 4

<tbody>
</tbody>

Thanks.

 

[ravishankar]

try the following codes

Sub daroh()
Dim x As Long, c As Long, d As Long, b As Long
Dim e As String
d = 0
x = Cells(Rows.Count, 1).End(xlUp).Row


       e = InputBox("enter student name")
       c = Application.WorksheetFunction.Match(e, Range("A2:A" & x), False) + 1
       
  For b = 2 To 25
  If Cells(c, b) <> "" Then
  Cells(x + 2 + d, 1) = Cells(c, b)
  d = d + 1
End If
Next b
  MsgBox "complete"
End Sub

ravishankar