You could use an Advanced Filter to extract the names. There are
instructions in Excel's help, and he

http://www.contextures.com/xladvfilter01.html

Then, use en event procedure to automate the filter. For an example, see:

http://www.contextures.com/excelfiles.html

Under filters, look for: Phone List for Selected Name
Instead using all the headings, just use FirstName.
In the code, change the CopyToRange to:

CopyToRange:=wsD.Range("C6")


Defoes Right Boot wrote:
My first column is a list of surnames so non-unique data. My second is a list
of first names, again non-unique but there is no duplication of the
combination of surnames and first names. I need to list all the first names
which go with an individual surname.

eg
Brown John
Brown Peter
Brown Michael
Smith John
Smith David
Jones Peter
Jones David

(but about 500 rows altogether) and I need to be able to, using the above
example, enter Smith in a cell and get a list showing "John" and "David", or
enter Jones and get "Peter" and "David"

Can someone help? Please?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html