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!