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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mitmeez - 08 Dec 2004 00:13 GMT

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

Reply to this Message

Duane Hookom - 08 Dec 2004 02:49 GMT

Consider asking in an Excel News Group.

Signature

Duane Hookom
MS Access MVP

> 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

Reply to this Message

John Vinson - 08 Dec 2004 03:05 GMT

>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

Reply to this Message