View Single Post
  #2   Report Post  
Bill Manville
 
Posts: n/a
Default

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