|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 20th, 2005, 03:17 AM
|
|||
|
|||
linking cell value in one workbook to a cell in another workbook
Hi,
How do I link two workbooks in Excel 2000 so that I can link two cells; one in one workbook and the other in another workbook? Thanks, Jig. 
|
|
#2
January 20th, 2005, 06:12 PM
|
|||
|
|||
|
Jig Bhakta wrote:
How do I link two workbooks in Excel 2000 so that I can link two cells; one in one workbook and the other in another workbook? Edit / Copy the source cell Edit / Paste Special / Paste Link in the destination cell. OR Type = in the destination cell Window to the source workbook Select the source cell Hit Enter Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Link to a cell in another workbook by name rather than absolute c. | Marc G | New Users | 2 | January 5th, 2005 09:15 PM |
| auto-generate a number in a cell on opening new workbook | Robb27 | Worksheet Functions | 1 | September 24th, 2004 06:33 PM |
| IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |
| Do you have what it takes... | darno | Worksheet Functions | 0 | February 22nd, 2004 08:01 PM |
| linking to another workbook | Sharon | Worksheet Functions | 1 | October 20th, 2003 09:29 PM |
Linear Mode
