Ask Experts Questions for FREE Help !
Ask
    drtarek's Avatar
    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's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    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's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #3

    Jul 16, 2009, 05:10 AM
    Quote Originally Posted by ScottGem View Post
    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's Avatar
    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's Avatar
    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's Avatar
    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.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


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...

98 accord making clunking noise when making hard left turn [ 3 Answers ]

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...

View more questions Search