Hi Patrick, I know you are disturbed by yesterdays post..and I see someone
has re-posted that as a reply...Well; here OPs requirement is slightly
different from what you have suggested....and hence need a bit more
coding..Thanks


"Patrick Molloy" wrote:

this will copy every entry on sheet2 to the same cell on sheet1. There's
nothing clever here. Right-click sheet2's tab, select View Code and paste
this code..its pretty apparent what it does

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Worksheets("sheet1").Range(Target.Address).Value = Target.Value
End Sub



"Looping through" wrote:

Is it possible to type some text into a cell on page 2 and force the changes
to a matching cell in sheet 1.

I.E
Sheet 2 line # 386, Note (Cell P386) = "10/1/09 - Should get order. 9/15/09
- Rep to follow up next week"
Sheet 1 line 1000, Note (Cell P1000 = "9/15/09 - Rep to follow up next week"

I want to be able to duplicate the notes in both worksheets without having
to go find the referenced line item and re-type the same info twice. My hope
is to keep everything consistant between sheets.

FYI... the line items will share a common # in Cell B.

Any help or direction will be great