ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I selectively import data from another Excel worksheet? (https://www.excelbanter.com/excel-discussion-misc-queries/25345-how-do-i-selectively-import-data-another-excel-worksheet.html)

Emmanuel

How do I selectively import data from another Excel worksheet?
 
I have a long database, that contains complete leads data with many columns.
I have another, shorter database that contains no data except one common
field between the two. I want to fill-in the info from the large database
into the smaller database. I'd sure appreciate help!
Thanks.

Gary Brown

Take a look at the vLookup worksheet function.
HTH,
--
Gary Brown



"Emmanuel" wrote:

I have a long database, that contains complete leads data with many columns.
I have another, shorter database that contains no data except one common
field between the two. I want to fill-in the info from the large database
into the smaller database. I'd sure appreciate help!
Thanks.



All times are GMT +1. The time now is 03:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com