I'm in a bit of a pickle here...


On sheet1, cell b3, I have a validated list of names.
On sheet2, I have a range of data, ColA has the same names as cell b3 on sheet1, and col b has ID #'s.

Sheet 2 looks something like this ::

Bob 123
Bob 231
Bob 312
Mary 423
Mary 234
Mary 342

What I need to happen is when I select a name from the cell b3 on sheet1 is for all of the IDs that match that same name on sheet2 to populate onto sheet1 in the range b6:b30

I understand this is an advanced filter function (don't know if it can be done i vba) but even trying various vlookup combinations, I can't get it to work and would greatly appreciate any assistance anyone could offer.