How can a cell in one workbook be linked to data in another workbook. Kenneth
K Kenneth May 26, 2004 #1 How can a cell in one workbook be linked to data in another workbook. Kenneth
F Frank Kabel May 26, 2004 #2 Hi try the following: - open both workbooks - in the target workbook enter the equatrion sign '=' - now select with your mouse the source cell in the other workbook and hit ENTER
Hi try the following: - open both workbooks - in the target workbook enter the equatrion sign '=' - now select with your mouse the source cell in the other workbook and hit ENTER
J Jon Peltier May 26, 2004 #3 Or copy the source cell, select the target cell, choose Paste Special from the Edit menu, and select Paste Link. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______
Or copy the source cell, select the target cell, choose Paste Special from the Edit menu, and select Paste Link. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______
K Kenneth May 31, 2004 #4 Many thanks to both Frank and Jon for your responses. Your help is much appreciated Regards, Kenneth
