drtarek Posts: 1, Reputation: 1 New Member #1 Jul 16, 2009, 01:47 AM
Making a link between two cells in two different sheets
How to link a cell to another cell in two different sheets?

Making a link between two cells in two different sheets
 ScottGem Posts: 64,966, Reputation: 6056 Computer Expert and Renaissance Man #2 Jul 16, 2009, 04:50 AM

=Sheet1!a1

Will link the cell you place that formula in to cell A! In Sheet1.
 JBeaucaire Posts: 5,426, Reputation: 997 Software Expert #3 Jul 16, 2009, 05:10 AM
Originally Posted by ScottGem

=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 Posts: 2, Reputation: 1 New Member #4 May 3, 2011, 07:20 PM
Comment on JBeaucaire's post
It is the manually input month that I want to update between several sheets by just updating the first
 GarageButler Posts: 2, Reputation: 1 New Member #5 May 3, 2011, 07:23 PM
Comment on ScottGem's post
That didn't work, it just placed that formula in the cell, does it make a diffence if it isn't numbers
 ScottGem Posts: 64,966, Reputation: 6056 Computer Expert and Renaissance Man #6 May 3, 2011, 07:29 PM

If you did it right it should display what is in the cell you referenced.

 Question Tools Search this Question Search this Question: Advanced Search

Check out some similar questions!

Link excel graph why axis min/max scale to cells [ 1 Answers ]

Hi , Thank you for allowing me to even ask a question. I hope I can make this simple and clear as to not confuse you. I am currently building an excel file. I will have 2 graphs on a sheet. One of the graphs I need to link the Y axis minimum and maximum scale, (and major unit if possible)...

Link spread sheets sheet 1 to sheet 2 , 2 to sheet 3 [ 4 Answers ]

I have attach what I have done on the site. What I need to do is link all of the data from sheet one to sheet 2. All I have found so far is how to link one cell to the other cell. In sheet 1 I have af 3 to af 699 . I need to bring all that data to sheet 2 to (d3 to d24) Sheet 2 will link into...

My 98 accord ia making a clunk, clunk, clunk sound when making hard left turns. It only does this with left turns a slow speed like making a u-turn. It actually seems to make the car bounce a little with each clunk. It is definitely not a clicking noise. I have just put a prelude h22 engine with...

Clicking differnet cells and it selecting all cells [ 2 Answers ]

Just wondered if anyone knew what I did to get ms excel to select all cells from A1 to what ever cell I clicked on. Thought it was sticky keys but it was turned off. Clicked left mouse button and it moved cells then when I clicked other cells it started using that as a new ref point and selecting...