MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Innes on February 05, 2002 6:18 PM

I know everyone will think i'm retarded, but I don't know how to reference information from one workbook too another. Exactly what am I supposed to type or do?

Posted by Paul on February 05, 2002 6:47 PM

use something like =[Book2]Sheet1!$A$1 (NT)

Posted by Chris D on February 06, 2002 12:40 PM

type "=" or "+" then click on the required cell in the desired worksheet within the required workbook with your mouse....

the result, if you're not manually typing it, will be exactly as Paul says.

As an aside, my Boss always types his links in manually, ditto numbers, as he says it forces him to appreciate where they come from, rather than just relying on the logic of links.... fair comment, but it gets inefficient after you reach a certain level of proficiency but then relevant once again, I guess, as you gravitate towards VBA coding.