View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Referencing Data

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!