I have two excel workbooks I am working with. I am filling data from one
workbook (lets call it wkb1) by finding a country name, taking the
corresponding currency, and placing that data into an other workbook (wkb2).
The common fields in both wkbk's are the country name, but the prices are
missing in wkb2. Is there any way to quick fill the second wkbk by doing a
mass fill, or by creating a function that will search wkb2 with the name of
the country from wkb1, and fill in the corresponding data from wkb1? Does
this require a macro or visual basic?

Thanks,

B

B

Have a read on VLOOKUP from Help.

OR go to Debra Dalgleish's site for VLOOKUP examples.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben Excel MVP

On Tue, 19 Apr 2005 08:56:02 -0700, "bosbill"
wrote:

I have two excel workbooks I am working with. I am filling data from one
workbook (lets call it wkb1) by finding a country name, taking the
corresponding currency, and placing that data into an other workbook (wkb2).
The common fields in both wkbk's are the country name, but the prices are
missing in wkb2. Is there any way to quick fill the second wkbk by doing a
mass fill, or by creating a function that will search wkb2 with the name of
the country from wkb1, and fill in the corresponding data from wkb1? Does
this require a macro or visual basic?

Thanks,

B