View Full Version : Making a link between two cells in two different sheets
drtarek
Jul 16, 2009, 01:47 AM
How to link a cell to another cell in two different sheets?
Making a link between two cells in two different sheets
ScottGem
Jul 16, 2009, 04:50 AM
You link a cell by referencing its address
=Sheet1!a1
Will link the cell you place that formula in to cell A! In Sheet1.
JBeaucaire
Jul 16, 2009, 05:10 AM
You link a cell by referencing its address
=Sheet1!A1
Will link the cell you place that formula in to cell A! in Sheet1.
... so depending on what you meant by "two" sheets, refer to each sheet individually.
If you want to subtract Sheet2!a1 from sheet1!A1
=Sheet2!A1 - Sheet1!A1
Beyond simple addition and subtraction, it gets tricky. If you provide an example of what you mean by "linking" (what do you want these links to accomplish?) then perhaps we can help more specifically.
GarageButler
May 3, 2011, 07:20 PM
It is the manually input month that I want to update between several sheets by just updating the first
GarageButler
May 3, 2011, 07:23 PM
That didn't work, it just placed that formula in the cell, does it make a diffence if it isn't numbers
ScottGem
May 3, 2011, 07:29 PM
If you did it right it should display what is in the cell you referenced.