how to get an value from a different book
 

hi

i have to .xls files - and i need to get an number from another workbook.

My book nr 1 have this
A1: (Itemnumberr) B1...G1 (some text). H1 (item weight)

Booknr 2;
A1 (itemnumber)....B1....K1 (some text) L1 (item weight)

What funktion is my best solution to get the item weight from book 2 into
book 1

--
Mortenn

First go to book1 and copy the cell in question.
Then go to book and Paste Special with the link check box checked.
--
Gary''s Student


"Mortenn" wrote:

hi

i have to .xls files - and i need to get an number from another workbook.

My book nr 1 have this
A1: (Itemnumberr) B1...G1 (some text). H1 (item weight)

Booknr 2;
A1 (itemnumber)....B1....K1 (some text) L1 (item weight)

What funktion is my best solution to get the item weight from book 2 into
book 1

--
Mortenn

ok - i need to be more specific ...

this have to be an automated import form one book til another, an lookup
function

--
Mortenn


"Gary''s Student" wrote:

First go to book1 and copy the cell in question.
Then go to book and Paste Special with the link check box checked.
--
Gary''s Student


"Mortenn" wrote:

hi

i have to .xls files - and i need to get an number from another workbook.

My book nr 1 have this
A1: (Itemnumberr) B1...G1 (some text). H1 (item weight)

Booknr 2;
A1 (itemnumber)....B1....K1 (some text) L1 (item weight)

What funktion is my best solution to get the item weight from book 2 into
book 1

--
Mortenn