We have a file on excel that has customer name, company name, comments, payments,and date of payments, know this report is updated everyday and every day it is saved under the date of the record, we keep in track with the record with a line # meaning Column A has the record number that this record belong to,  recently we had a new employee that filter the data by customer name and now the records do not match with the line number, we have the date of the occurrence, is there a way to correct the information using the last correct record and the line number to correct the other records.

---

Reply from Alex Hedley:

Can these numbers now not be updated as they are active?