copy range from one workbook to another

  • Thread starter Thread starter stef
  • Start date Start date
S

stef

Excel 2002 SP3
Win XP Pro SP2

Hi,

Even though I saw the documentation a while ago, I cannot remember how
to copy a named range in workbook 2 to workbook A--the reason is that I
want to do a VLOOKUP in workbook A, to lookup value xyz in rangem in
workbook B.

Thus I figured I would/needed to copy rangem (in workbook B) to workbook A.

Perhaps it is not the best way but I would appreciate the answer to how
to copy the range; and if any other better way of doing the lookup
between separate worksbooks, please let me know.

Thanks.
 
Hi Stef,

You can do the lookup with the table array in another workbook.

=VLOOKUP(A1,'WorkBook with Table Array.xls'!MyLookupRange,2,FALSE)
 
Yep it worked.
I also found it again in the Help File (oops!) and had to try it several
times before it would work.
I think the "Save" step prior to the procedure to copy needs to be
done--per the help file--even if it seems odd.
I got it to work finally, and noticed that you can just as well write it
in, as you have suggested.
Thanks.
 
Back
Top