Hi Gary:

I used your macro and it worked great....now, though, I want to create a
macro to do almost the same thing, except I want it to retrieve more than 1
field of data for the person...Can I tweak this one to do what I want?

I want it to say say: If "Doe, Jane" is found by auto-filter in Column A
from
Cell A2:A160 in Worksheet 2 , Take the data in Column A through Column L and
copy to Worksheet 1 "Jane D" in Cells A4 to L14.

How can i do that? You are terrific and I'm so new to this, I really
appreciate it.

--
jeannie v