MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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!


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.

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!

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?

Posted by cpod on January 20, 2001 6:43 AM


Just link the first cell in the column and copy down.