Make a cell value depend on another Worksheet's cell value

[MariPip]

So I know this is a really basic thing, but I'm kind of lost..
I have a worksheet named CAPA, and another named comp.norm.
I need for cell D2 from comp.norm. to always have the same value of CAPA's cell C3, which will be changed constantly..
thanks for any help!

 

[bbott]

In cell D2:

='CAPA'!C3

 

[Snakehips]

MariPip,

In D2 of comp.norm Type = then select sheet CAPA and it's cell C3 then hit return and you should see...

=CAPA!C3 in cellD2

You could of course just type =CAPA!C3 directly into D2 if you remember that the sheet name needs to be followed by an exclamation point !

If by chance the sheet name contains spaces e.g. CA PA then you would need the sheet name enclosed by single quote marks as in..

='CA PA'!C3

Hope that helps.

 

[MariPip]

Thank you

 

[Snakehips]

You are welcome.

Thanks for the feedback.