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!

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

"Bull427" wrote:

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!

Hi,

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

=Sheet2!A1

Mike

"Bull427" wrote:

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!

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.

"Sean Timmons" wrote:

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

"Bull427" wrote:

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!

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

"Mike H" wrote:

Hi,

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

=Sheet2!A1

Mike

"Bull427" wrote:

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!