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

    Feb 23, 2008, 08:55 AM
    Linking cells that can update automatically
    I have 2 sheets.Sheet 2 cell E5 has a number 123 I want to link it to sheet 1 A4 but when I get to A5 it must be updated automatically to E5 sheet 2:mad:
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Feb 23, 2008, 09:33 AM
    On sheet 1 in cell A4, put this: =Sheet2!E5

    Now anything on sheet 2 in cell E5 will show on sheet 1 in cell A4. Automatically.

    Your second comment makes me think you want anything you type in cell A4 to transfer automaticaly BACK to Sheet2!E5, and that's not possible with basic formulas. References go one way or the other. If you want what you type on Sheet 1 to be the one in charge, then reverse what I've suggested and put =Sheet1!A4 on sheet 2 cell E5 and now it will reference.

    To have two cells equally transfer input back and forth regadless of which cell you change COULD be accomplished with a VBS script, but that's opening a can of worms you may not be ready for.
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!

How to update AVG antivirus Update to computer,which is not connect with internet [ 2 Answers ]

Hello, Computer (No.A) is connected with internet. So I can get the update automatically. But, Computer (No.B, and No.C ) is not connect with internet. But we use the flash Drive and 3 1/2 Floppy disk. Without antivirus software, No.B & C can get the virus. Already having the antivirus software...

Linking tables [ 1 Answers ]

How to link tables

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

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

View more questions Search