copy range from one workbook to another

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.
 
O

OssieMac

Hi Stef,

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

=VLOOKUP(A1,'WorkBook with Table Array.xls'!MyLookupRange,2,FALSE)
 
S

stef

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copying sheet to other workbook and named ranges 2
Copying range of formulas to anotehr workbook 4
Copy a worksheet to a new workbook 6
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy range to multiple workbooks 2
How to create absolute link to cell in another workbook (Excel 2003) 1
Copy Multiple Areas from One Workbook to Another 4
copying a style from one worksheet to another in the same workbook 1

Top