Getting value from another excel file

L

ltamisin

Hello

I need to know the formula on how to get values from another excel file.

Help plsssssssssssssssss...

thanks
 
L

ltamisin

Hi Anne

Is there any other way or formula to do that? Coz if i do that there is a
textbox appearing in my worksheet and i have to fix the size in order to fit
the cell and that was very annoying becoz i have so many cell to link.

Pls help....

Thanks
Leo
 
B

Bob Phillips

When the other workbook is open

='[otherbook.xls]Sheet1'!$A$1

When it is closed, something along the lines of

='C:\MyTest\[otherbook.xls]Sheet1'!$A$1
 
D

Dave Peterson

Just to add to Bob's reply...

I like to open both workbooks.

Then start typing the formula with an equal sign.

=

Then go to the other workbook, other worksheet and click on the cell that I need
to return.

Then excel will build the formula.

Like Bob wrote, it'll look something like:

=[Book1.xls]Sheet1!$A$1

But if that cell is empty, this formula returns a 0.

So I'd modify it to:

=IF([Book1.xls]Sheet1!$A$1="","",[Book1.xls]Sheet1!$A$1)

And when I close book1.xls, xl will do all the drive/folder stuff for me.

=IF('C:\My Documents\excel\[Book1.xls]Sheet1'!$A$1="","",
'C:\My Documents\excel\[Book1.xls]Sheet1'!$A$1)

(all one cell)

Let excel do the heavy lifting so you don't have to remember any of the syntax.
 
Top