importing data from other offline workbooks

Originally Posted by budman182

hi i have a lot of different excel work books at work, utilization, expenditure reports.
anyway i need to take some values out of one work book and have them in a different one, but i'd like it to be automated, something like an advanced look up, or index function.

is there anyway i can do this? also can i specify which sheet to use in the offline workbook?

any help is much appreciated

cheers

Hi,

by 'offline' I presume that you mean not open.

The VLookup function will operate on a non-open workbook, but for other access you will need something like the MoreFunc add-in

hth
---
added, there is a download site at http://www.freewarehome.com/index.ht...e/Excel_t.html if you can stand the gawdy advert long enough to locate and get the file.
---

Originally Posted by Heyyouoverthere

Ok...

It seems that it works when I reference something directly with a string.
=VLOOKUP("12045808",[TestConnectorList.xls]MasterConnectorList!$A$2:$R$138,18,0)

Is there a way possible for me to reference a cell? That seems to be my issue as I would like to be able to refer to some cell in my main sheet(that is I would like to perform my lookup based on some cell in my current workbook).

Rather than interlope on this thread you should start a new thread with a reference back to here.

For your question, most functions will not work if the 'other' workbook is not currently open to you, VLookup is the exception which operates on open or closed books.

To use other functions, locate the MoreFunc addin and include it on your system.

hth
---