Linking cells across worksheets
Posted by John Hulsey on July 17, 2001 9:46 AM
I read this question and the answer already, but it wasn't quite what I am wondering. I know how to copy data from one cell to another. What I need to know is how to link cells in one worksheet to cells in another worksheet, so when I update the cells in worksheet 1 the updates to Worksheets 2-6 are automatic.
How do I LINK cells, not just copy data? Please copy me directly at JohnandRic@yahoo.com, so I can get my answer as soon as possible. Thanks SO MUCH!
(P.S. I have searched the Help menu until my eyes have crossed. I have found data on Updating Links, but not actually creating them. Argh!)
Posted by John Hulsey on July 17, 2001 10:04 AM
The answer is simple. Found it myself, finally. Select the source cell, select COPY, select the destination cell on the new worksheet, select PASTE SPECIAL, select PASTE LINK.
That's it. How cool is that? <smile>
