C
cdegar01
Hello all. I have a bit of a problem.
I have two workbooks, [Book1] and [Book2]. In [Book2], I have a cell A
with "=[Book1]Sheet1!$B$2" in it. The result is that A1 read
"Operating Margins."
What I want to know how to do is create formulas in [Book2] that wil
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 com
from [Book1].
I hope this isn't too confusing. Thanks
I have two workbooks, [Book1] and [Book2]. In [Book2], I have a cell A
with "=[Book1]Sheet1!$B$2" in it. The result is that A1 read
"Operating Margins."
What I want to know how to do is create formulas in [Book2] that wil
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 com
from [Book1].
I hope this isn't too confusing. Thanks