Reference to Cell in Other WSheet in WBook

[Kevin Sprinkel]

We develop conceptual cost estimates for schematic design
of buildings. Frequently we have multiple worksheets
(Estimate, Summary, Area, etc.) that have a common header
of five fields. I'd like all but one to get their values
from one authoritative worksheet, but when I enter the
cell reference (by pointing to it), it inserts the cell
reference rather than the value, as in:

=Estimate!B1:B1

There must be a parameter set somewhere but I can't find
it. Anyone know how?

Thanks.

Kevin Sprinkel
Becker & Frondorf

 

[Eva Shanley]

Make sure the cell your formula's in is not formatted as
text; if it is text you'll always get the reference
instead of the actual cell values. Hope this helps.

 

[Kevin Sprinkel]

That was it, Eva. Thanks.

Kevin Sprinkel
Becker & Frondorf

Conceptual Cost Estimators
& Project Managers as Owners' Representatives