Excel 2007
 

I wish to know how to make information in a cell in Book 1, Sheet 1, show up
automatically in a cell on a different sheet (s) in Book 1.

Excel 2007
 

Copy the cell you want to show up in the different sheet, then go to the
sheet you want it to show up in, click on the cell you want it in and hit
Paste Special, Links.

"bobrwag" wrote in message
...
I wish to know how to make information in a cell in Book 1, Sheet 1, show
up
automatically in a cell on a different sheet (s) in Book 1.