linking data

  • Thread starter Thread starter JR Winder
  • Start date Start date
J

JR Winder

Is it possible to have one spreadsheet (A) linked to another spreadsheet (B)
so that any changes made to (A) are automatically recorded in (B)?
 
JR
The simplest way to do this, as I can see, is to use a Worksheet_Change
event macro in sheet A that will copy any changes (in sheet A) to sheet B.
Does this sound like what you might want? HTH Otto
 
Something like this perhaps:
Private Sub Worksheet_Change(ByVal Target As Range)
Target.Copy Sheets("B").Range(Target.Address)(1)
End Sub
 
Yep.

See help on "linking workbooks" and "create a link to another cell, worksheet or
workbook"


Gord Dibben MS Excel MVP
 
Back
Top