Ask Experts Questions for FREE Help !
Ask
    pcannon's Avatar
    pcannon Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Sep 11, 2006, 09:20 AM
    Linking Cell Within Same Book
    Hello::confused:

    How do I link cells in worksheet to cells in another worksheet within the same book?

    When editing data in a worksheet, I would like for it to automatically update the summary page.

    Thanks
    PCan
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Sep 11, 2006, 10:47 AM
    =celladdress

    For example, if you want the value in cell Sheet1!A1 to show up in cell Sheet2!A1, just type = and the cell address.
    StuMegu's Avatar
    StuMegu Posts: 576, Reputation: 64
    Senior Member
    		  
    #3

    Sep 12, 2006, 05:54 AM
    You can also type "=" in the cell and then click the cell that you want to reference. Just type = on the summary page, then click the sheet with the info on it and then the cell and press return. Go back to the original cell and it should reference the source using the format that Scott described.

    Good Luck!
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!

Cell phones [ 2 Answers ]

How do I know that a cell phone is unlocked? I purchased one that was supposedly unlocked but I cannot connect to my active service provider.

Excel: Linking from one worksheet to another [ 8 Answers ]

I'd like to link from a cell in one worksheet to a LINE in another. If that doesn't make sense, I've got a member list of people with address, phone, etc. For folk that have not renewed this year, I want to have a separate worksheet that documents my contact efforts... so to link from the...

Linking a banner [ 2 Answers ]

My friend asked me the code used to link a banner pic inserted in his email to his website. He wishes to put the animated banner in his emails and have the recipient be able to click the banner and be directed to his website. The first question is how to insert the banner picture into his...

Cell [ 2 Answers ]

What are all the organelles of a cell and there definitions?

View more questions Search