how to get an value from a different book

M

Mortenn

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
 
G

Gary''s Student

First go to book1 and copy the cell in question.
Then go to book and Paste Special with the link check box checked.
 
M

Mortenn

ok - i need to be more specific ...

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