References, Formulas, Offset! Help!

  • Thread starter Thread starter cdegar01
  • Start date Start date
C

cdegar01

Hello all. I have a bit of a problem.

I have two workbooks, [Book1] and [Book2]. In [Book2], I have a cell
A1 with "=[Book1]Sheet1!$B$2" in it. The result is that A1 reads
"Operating Margins."

What I want to know how to do is create formulas in [Book2] that will
return values in [Book1] offset from the reference in A1.

In the end, I will simply link on cell in [Book2] to a cell in [Book1],
and maybe 20 cells in [Book2] will automatically have values that come
from [Book1].

I hope this isn't too confusing. Thanks!
 
please do not cross post, see your thread in Excel.misc
Click to expand...

The OP did *NOT* 'crosspost'. The OP 'multiposted'. There's a difference. Use
the terminology correctly.
 
Back
Top