Searching Multiple Times

[butlerr]

In column 'A' I have a list of 10 different people, but there are 130 entries, so a lot of repeating.

In column 'B' I have a list a items each person has chosen (nothing repeating)

Now in, say, column 'C' I want to list all items chosen by one particular person.

I can search for a name and find their first item, but I don't know how to find the 2nd occurrence of that persons name and entering its choice, and so on.

This is what I have for the first entry:
=VLOOKUP(G1,DraftingPlayer,2,FALSE)

"DraftingPlayer" is the name range for column A and B.
G1 is a cell that contains one of my names (Brett)

Any help would be much appreciated!

 

[sulakvea]

change these two things:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.ScreenUpdating = False
LR = Sheet2.Range("C" & Rows.Count).End(xlUp).Row
i = 7
With Sheet2.Range("C3:C" & LR)
Set c = .Find(Sheet3.Range("A1").Value, LookIn:=xlValues, lookat:=xlWhole)
If Not c Is Nothing Then
firstaddress = c.Address
Do
Sheet3.Cells(i, 3).Value = c.Offset(0, 1).Value
i = i + 1
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address <> firstaddress
End If
End With
Application.ScreenUpdating = True
End Sub

everything else seems in tact with what i wrote

 

[butlerr]

Ah man, I really appreciate you trying to help me out here, but I don't think it's going to work for me, I need to learn more about VBA first.

I put in your code, it kinda worked, but it placed the results in Column C, not in Column A, not sure where to change that. As well it placed the first result in C19 and the second result in C7, not sure why.

And once I figure this out, I have to do it 9 more times (for all of my names), so I wouldn't know the process there.

If you feel like not helping out anymore I completely understand. I'm not trained well enough yet.

 

[sulakvea]

for that, change the i=3 in this line: Sheet3.Cells(i, 3).Value = c.Offset(0, 1).Value with corresponding column index.

Col a = 1, Col b = 2, etc

 

[butlerr]

ok, got it to work now. except it is putting the first result at the bottom of the list. Do you know how to put it at the top?

and once we have that, Do I just copy and paste this 9 more times in the same page. I think there would be a few small other changes, but can you put 10 different codes in the same sheet?

 

[butlerr]

Got it! I kept looking and I actually found a way to do it without VBA (thank god, cause I had no clue how to edit that stuff)

http://www.mrexcel.com/forum/showthread.php?t=479422