User input data to stay in same row as variable data

Hello, what I am trying to do is create a "Notes" column, in which the data in the relative cells remains in the same row as a variable number. For example, in the attached Image, the whole table which includes the column "A/R Cust" varies each week. In other words, the A/R Cust number may move 3 or 4 rows up or down, depending on which customers are added or removed, but I want the notes that a user inputs to remain in the same row as the customer number. I have tried for hours and hours trying to find a formula or VB that will work, and some things get close, but just never do the trick. Any advice? Thanks!

Screen Shot 2015-10-27 at 11.35.53 AM.png