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

    Apr 24, 2008, 10:26 AM
    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.
    retsoksirhc's Avatar
    retsoksirhc Posts: 912, Reputation: 71
    Senior Member
    		  
    #2

    Apr 24, 2008, 10:38 AM
    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.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #3

    Apr 24, 2008, 10:53 AM
    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.
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!

EXCEL - Wrap Text not working! [ 14 Answers ]

Hi I have a spreadsheet with one column having quite a bit of data in it. I have tried to 'wrap text' as well as 'auto-fit' within the row to no avail. Some of the information is still not visible no matter what I do. I have exhausted all possible options including excel help online and...

Outlook Links not Working [ 12 Answers ]

For some reason I cannot open hyperlinks in Outlook. When I click on the link in a message in Outlook, nothing happens. If you know how to fix this or where I can go for help, I would appreciate your assistance!

Internet Explore Links Not Working [ 1 Answers ]

I am having problems with my IE. When I click on a link that requires a new window to be opened, it will not open. It will only show the toolbars and the outline of the window. I have removed a pop-up blocker that was installed a while back and have uninstalled my Google toolbar. I even...

View more questions Search