Archive of Mr Excel Message Board
Back to Links in Excel archive index
Back to archive home
Linking cells in different worksheets
Posted by Christi on January 09, 2001 11:02 AM
I have a workbook with several worksheets in it. Is there a way I can link cells so that if data in a cell on one worksheet is changed, the same data in another worksheet is also changed? This would save me so much time!
Re: Linking cells in different worksheets
Posted by cpod on January 09, 2001 11:16 AM
You poor thing! Have you been updating information more than once? To copy data from one cell to another just enter the cell type and equal sign and then select the cell you want to link to (it will get dotted lines around it) then press enter.
Re: Linking cells in different worksheets
Posted by Christi on January 15, 2001 6:32 AM
Cpod, you are the best! Once I get everything linked, it will free up so much time. Thanks so much!
Re: Linking cells in different worksheets
Posted by Christi on January 15, 2001 6:52 AM
Cpod, you are the best! Once I get everything linked, it will free up so much time. Thanks so much!
How about linking entire columns? Is that as easy as linking cells?
Re: Linking cells in different worksheets
Posted by cpod on January 20, 2001 6:43 AM
Just link the first cell in the column and copy down.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.