I am in a issue. There is sheet with three possible columsn – where user can enter the data and changes the existing value. How do I flag the rows using worksheet change event of any other VBA ways - that will tell me that a particular row has been changed if any of the three column (C1,C2,C3) values have changed for a row.
For example: if C1 column value of row 7 has changed, and if C3 value of row 10 has changed, then those two rows are flagged as “changed” somehow and a new column or something stores that info.
I am doing this so that I can auto filter by that “CHANGED ” COLUMN
C1 C2 C3 dsads
wq e ew
qwe wqe wqe