How can a cell in one workbook be linked to data in another workbook.
Kenneth

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Kenneth" <(E-Mail Removed)> schrieb im Newsbeitrag
news:(E-Mail Removed)...
> How can a cell in one workbook be linked to data in another workbook.
> Kenneth
>
>

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/
_______

Frank Kabel wrote:

> 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
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
>
> "Kenneth" <(E-Mail Removed)> schrieb im Newsbeitrag
> news:(E-Mail Removed)...
>
>>How can a cell in one workbook be linked to data in another workbook.
>>Kenneth
>>
>>
>
>

Many thanks to both Frank and Jon for your responses. Your help is much
appreciated

Regards, Kenneth