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