如何更新固定列中的单元格，而不是动态行，以便在更新相应行中的另一个单元格时进行更改？

I have a set of data where I want Column AV to update with the word "Manual" in the row that corresponds to a row a change was made in.I have a set of data where I want Column AV to