Referencing Data

[Bull427]

Is there a way to reference the data in a cell on a different sheet? In
other words, on a cell on Sheet A, I want to reference the data in a cell on
Sheet B so that whenever I update the cell on Sheet B, the cell on Sheet A
will automatically update itself.

Thanks!

 

[Sean Timmons]

Just click =, then go to the other sheet and click on the cell you want to
reference.

 

[Mike H]

Hi,

Tis on any sheet in the same workbook will keep the same value as Sheet2 A1

=Sheet2!A1

Mike

 

[Bull427]

After clicking on the cell I want to reference, do I need to do anything
else? It comes up in the first cell listing the sheet name and cell # it's
referencing but not the data.

Thanks.

 

[Bull427]

I got it. Thanks folks. I appreciate the help!

Hi,

Tis on any sheet in the same workbook will keep the same value as Sheet2 A1

=Sheet2!A1

Mike