vlookup with 2 different workbooks in macro
 

hello everyone,

is it possible to runa vlookup function within a workbook that creates a new
workbook and refenceces the workbook that create the new workbook....? it's
a little confusing...let me kmow if you have any questrions...

** the lookup table is in the macro workbook, but the vlookup formula is
created in the new workbook...

--
thanks,
himansu