linking data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JR Winder - 11 Dec 2007 20:38 GMT

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

Reply to this Message

Otto Moehrbach - 11 Dec 2007 21:18 GMT

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

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

Reply to this Message

Otto Moehrbach - 11 Dec 2007 21:25 GMT

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

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

Reply to this Message

Gord Dibben - 11 Dec 2007 21:30 GMT

Yep.

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

Gord Dibben MS Excel MVP

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

Reply to this Message