I've just updated to Office 2007 Standard. Previously I had been using Office 2000. In the past, whenever I wanted the info in a cell to appear from a cell in another worksheet/book, I would select the destination cell, click on the source cell and hit enter. From that time on, each time the data changed in the source cell it would be reflected automatically in the destination cell.

For the life of me, I can't figure out how to do this in Excel 2007! Can any body help?


Btw, The toolsbars that I was using in Excel 2000 were Standard and Formatting. I've watched the demos in Help concerning the toolbars in 2007, but no joy....

Thanks,

rver