Archive of Mr Excel Message Board
Back to Links in Excel archive index
Back to archive home
Linking Cells
Posted by JS on November 08, 2000 11:50 AM
Hi all,
Is there anyway to link cells between multiple worksheets so that they show the same value? I'm working with multiple sheets in my .xls file. Is there a way to link cells between 2 or more sheets so that a change in one is reflected in the others? For example, I have a group of values on sheet2 that are derived from formulas. I want to summarize those values on sheet1. Also, if values are changed in sheet2 depending on the input, I want that changed reflected on sheet1. Is that confusing enough?
Re: Linking Cells
Posted by Loren on November 08, 2000 12:34 PM
If you have data on sheet1, go to sheet2. Type =,
click sheet1, click target cell, enter. That creates
the link. YOu can have numerous links, but there
must be data at the beginning of the link.
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.