use data filter advanced filter. It is easier than a macro and pretty
powerful.

sheet2 (data)
Surname FirstName Date
Tyson Michael 04/05/99
Nelson Horatio 06/11/94
Jones Michael 12/08/65
Tyson Butch 07/31/84

sheet3 (criteria)
Surname FirstName Date
Tyson

sheet4 (where you will put the results)
Surname FirstName Date

now do this
- data filter advanced filter
- copy to another location
- list range (select your data on sheet2)
- criteria range (select sheet3 A1:C2)
- copy to (select sheet4 A1:C1)

ok

--
Allllen


"George" wrote:

I have a table (sheet2), which in column `A` have surnames and column `B`
first names, column `C` a date. What I`m after is to enter a surname in cell
M4(sheet1), this produces a list of all clients with that surname and first
names and date. I was after a vb code for this procedure. Can anybody help.
--
George