Referencing a cell in another workbook?

[danjuma]

Hello,

If I have two woork books opened. One named book 1 and containing sheet 1. The other named book 2 and containing sheet 1. How would I reference say cell A1 in book 2 sheet 1 from say cell A1 in book 1 sheet 1, so that cell A1 in book 1 sheet 1 contains the value in cell A1 in book 2 sheet 1?

Many thanks
Dan

 

[danjuma]

Ok, looks like I have worked it out.

 

[jeffreybrown]

Simply press the equal sign while in book 1 and then go to book 2 and select A1.

=[Book2]Sheet1!$A$1

 

[jproffer]

=[Book2]Sheet1!$A$1

 

[danjuma]

Thanks guys, I managed to figure it out. Cheers.