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

    Jun 17, 2012, 08:13 PM
    Connecting Cells in different worksheets
    Is there a method to connect 2 or more cells from different worksheets together in such a way that when any of the cells are changed, the rest automatically update. For example, I have three worksheets, sht1, sht2, sht3. Cell A1 of sht1 should be connected to cell A1 of Sht 2 and cell A1 of Sht3, If I make a change to cell A1 of any of the three worksheets, that change will be automatically shown in Cell A1 of the other two worksheets.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    Jun 18, 2012, 03:20 PM
    There is no formula that works both directions. This also sounds chaotic. A good sheet design would be to have ONE main sheet where you input data, and the other sheets use formulas to present subsets of the larger data.

    You can start the long and funfilled journey down the path of "programming" and start to develop macros which can be programmed to do pretty much anything, including this.

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!

Structural differences is that eukaryotic cells evolved from prokaryotic cells? [ 0 Answers ]

I have this for homework and don't get it? Can u plese help me? Thanks

Excel Worksheets [ 1 Answers ]

I have several worksheets in an Excel spreadsheet. Is there a way that I can print a list of the names of each of the worksheets in the spreadsheet?

Worksheets within the same workbook [ 21 Answers ]

Hi, I have many worksheets within the same file, what I really want is to have either a (link / go to option) from sheet1 to other sheets without using hyperlink because I want to send to others. Example: if I click on Apple from Sheet 1, I will go to Sheet2 Sheet1 Sheet2 ...

Protected worksheets [ 3 Answers ]

When you protect a worksheet in excel but unprotect certain cells, why can't you change the format of the cells or insert comments?

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