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. |
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. |
All times are GMT +1. The time now is 01:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com