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

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!