I have a large database which i'm continually updating. It has:

Col A Col B Col C Col D

Surnames First names Time In Time Out



what i'm wanting to do (in sheet 2) is for excel to look down column A and
if it sees the surname "Smith" i want it to copy the whole entry (whole row)
into sheet 2.

there may be 20 or so queries running at any given time though. That is, i
might want it to copy all occurances of surnames "Smith" and "Jones" and
"Brown" etc etc etc into sheet 2. not particularly bothered which rows it
copies them into as i can do a "sort" on them later.

Hope this makes sense !!!!

Regards
Andrew