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 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago