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!
Recent comments
5 years 42 weeks ago
6 years 28 weeks ago
6 years 40 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 49 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago