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.
![]() |
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.
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.
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. |