Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Do spreadsheets talk? (https://www.askmehelpdesk.com/showthread.php?t=415413)

  • Nov 12, 2009, 02:00 PM
    MJackson1
    Do spreadsheets talk?
    What are the steps that a spreadsheet uses to communicate with other spreadsheets?
  • Nov 12, 2009, 05:56 PM
    JBeaucaire

    Spreadsheets communicate with each other:

    1) With formulaic links to specific workbooks, specific sheets, and specific cells.

    Links can simply be directly reflecting a value from one cell in one workbook into the current cell, or many Excel functions can be applied to the values of cells in other workbooks to bring completely different results into the current workbook.

    2) With VBA programming

    Macros can be used to open other workbooks, collect or create data, and place the data into the current workbook (or multiple workbooks) without the need for realtime formulas.

  • All times are GMT -7. The time now is 10:56 PM.