It`s not working. I keep getting a message "Reference is not valid". Is it
possible to just have two sheets, rather then three?
--
George
"Allllen" wrote:
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