Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Other Programming (https://www.askmehelpdesk.com/forumdisplay.php?f=437)
-   -   Working with Excel Links (https://www.askmehelpdesk.com/showthread.php?t=209147)

  • Apr 24, 2008, 10:26 AM
    BLM001
    Working with Excel Links
    I have a master spreadsheet (it is a price list) with multiple rows of information, organized by columns. I need to link the information in each row to different excel work sheets.
  • Apr 24, 2008, 10:38 AM
    retsoksirhc
    That's not too hard to do once someone actually shows you, but it's awfully hard to guess on your own.

    To reference a cell on another sheet, you use 'Name of sheet'!CellNumber

    If the sheet anme is one word, you don't need the quotes.

    =SUM(Sheet1!A1:G1) for example, could be a formula on Sheet 2, and it would pull the values automatically.
  • Apr 24, 2008, 10:53 AM
    ScottGem
    You need to define what you want to accomplish by linking. Its not hard to link a cell in one sheet to a cell in another workbook and/or sheet. But depending on what you want to accomplish it may be more involved.

  • All times are GMT -7. The time now is 06:41 PM.