Simultaneous Postings

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Followup to my first posting question. How can I
simultaneously post information to different worksheets if
the cell positions are different on each sheet? Is there a
formula?
Thanks,
Bill
 
One way. Right click on sheet tab>view code>insert this>modify to suit>save
workbook

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$C$1" Then Exit Sub
[sheet3!f8] = Target
[sheet1!z12] = Target
'etc
End Sub
 
One way is to create a link between the individual cells.

Once the link is made, any change (data, not formats) to the original
(source) cell will be reflected in the other (destination) cell. More then
one cell can be linked to the source.

For example, to link cell A1 on Sheet1 to cell C2 on Sheet2:
Type "TEST" into A1, then right click in A1 and choose COPY,
Navigate to Sheet2 and right click in C2, and choose "PasteSpecial",
Then just click on the "PasteLink" button.
You should now see "TEST" displayed in C2.

Go back to Sheet1 and change the contents of A1, and you will see this
change reflected in C2 of Sheet2.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Back
Top