Log in

View Full Version : Working with Excel Links


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