Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Connecting Cells in different worksheets (https://www.askmehelpdesk.com/showthread.php?t=672105)

  • Jun 17, 2012, 08:13 PM
    Mongoose62
    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.
  • Jun 18, 2012, 03:20 PM
    JBeaucaire
    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.

  • All times are GMT -7. The time now is 11:01 PM.