how to get an value from a different book

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
First go to book1 and copy the cell in question.
Then go to book and Paste Special with the link check box checked.
 
ok - i need to be more specific ...

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

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

Copy/Paste formulas in merged cells 2
Getting a #VALUE! error---Need help 5
List to a table format 6
Changing the Helper Column 12
Scrabble Value calculation for Welsh words 0
Please help...I am at work and have a 3pm PST deadline... 14
if multiple values same/others different, return true 7
How do I summarise data from several workbooks? 4

Back
Top