View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default Linking 2 workbooks

Hi Jacob

On sheet1 in cell A1
=Sheet2!A2

Regards

Roger Govier


jacob wrote:
How do you link a cell to another cell in a different workbook?

for example:
Book1 Sheet1 cell A1 to Book2 Sheet2 cell A2