View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bull427 Bull427 is offline
external usenet poster
 
Posts: 3
Default Referencing Data

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!