Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
Linking Excel Worksheets.
Posted by - NA - on 01 April 2006 05:45 AM
|
|
Solution: There are times when we can store some of our data on one worksheet and then link that data to another worksheet in the same workbook. As an example of how to do this, open a blank workbook and select Sheet3. Into cell A1, type 27 and press Enter. Now, click the Sheet1 tab and then click in cell A1. Type =sheet3!a1 and press Enter. Cell A1 on Sheet1 will now display 27 (the contents of cell A1 on Sheet3). | |
|
Comments (0)