linking data

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)?
 
O

Otto Moehrbach

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
 
O

Otto Moehrbach

Something like this perhaps:
Private Sub Worksheet_Change(ByVal Target As Range)
Target.Copy Sheets("B").Range(Target.Address)(1)
End Sub
 
G

Gord Dibben

Yep.

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


Gord Dibben MS Excel MVP
 
Top