link two workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Friends,

Is there a way to link the cells in WorkbookA.Sheet1 to the cells in
WorkbookB.Sheet1 without having the link formula appear inside the cells of
WorkbookA.Sheet1?

Or is copy \ paste special \ links the only type of link that can be created
between two workbooks?

I am trying to create a macro that: 1) clears the data (so that nothing
appears in the linked cells); 2) updates the link (so that only values (not
link formulas) appear in the updated cells).

Thanks,

Bill Morgan
 
Back
Top