Home |
Search |
Today's Posts |
#1
|
|||
|
|||
copy range of cells from one workbook to another
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update linked cells within a workbook??? | Links and Linking in Excel | |||
Copy Cells | Excel Discussion (Misc queries) | |||
copy blank cells | Excel Discussion (Misc queries) | |||
how can I duplicate or copy a workbook then divide selected cells. | Excel Discussion (Misc queries) | |||
how to update a shared workbook using the same cells at the same t | Excel Discussion (Misc queries) |