Try this:
Open Both Workbooks
Select the Source Spreadsheet
Choose Cells and Copy
Select the Cell to Populate with Data
Establish a Link Between the Two Spreadsheets
(Right-click the target cell. Point to "Paste Special" and then press "N" to establish a link between the two spreadsheets.)
Regards,
Jerry
|