Can I copy 1 line of data from one workbook (the list)& put it in.

How can I take information from one workbook which contains a list, and using
one or 2 lines from that list to complete a form in another workbook? I have
a list of individuals who will be receiving bonus checks. I need to put the
information per individual on a check request form. The list is one workbook
and the check request form is another. I don't want to have to retype it due
to possible input errors. Both files are done on Microsoft Excel 2000 9.0.2

Consider asking in an Excel News Group.

--
Duane Hookom
MS Access MVP


"Mitmeez" wrote in message
...
How can I take information from one workbook which contains a list, and
using
one or 2 lines from that list to complete a form in another workbook? I
have
a list of individuals who will be receiving bonus checks. I need to put
the
information per individual on a check request form. The list is one
workbook
and the check request form is another. I don't want to have to retype it
due
to possible input errors. Both files are done on Microsoft Excel 2000
9.0.2

On Tue, 7 Dec 2004 16:13:01 -0800, "Mitmeez"
wrote:

How can I take information from one workbook which contains a list, and using
one or 2 lines from that list to complete a form in another workbook? I have
a list of individuals who will be receiving bonus checks. I need to put the
information per individual on a check request form. The list is one workbook
and the check request form is another. I don't want to have to retype it due
to possible input errors. Both files are done on Microsoft Excel 2000 9.0.2

Microsoft's flaky Help system has dumped you into the Microsoft Access
support newsgroup. Please scroll down and find an appropriate Excel
newsgroup (microsoft.public.excel.whatever - the volunteers there
should be able to help.

On the other hand... if you'ld like to implement this application in
Access, as a relational database it might be a better program for the
purpose; feel free to post back if you're interested!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps