Hi
try using vLOOKUP. See:
http://www.contextures.com/xlFunctions02.html

--
Regards
Frank Kabel
Frankfurt, Germany

"mitmeez" schrieb im Newsbeitrag
...
I have 2 workbooks. The 1st one is a list of individual names and
numbers.
One row per individual. The 2nd is a "request for manual check"
form.
Instead of retyping all that data is it possible to copy one line of
data
into the second workbook to complete the check request form? There
are only
3-4 fields that need to be completed on the form. I have about 100
employees
on the list and one form. Each employee needs his own request form.