Make comparisons to identify new rows/amendments to existing info
Each week I will get a new worksheet from an external source (hopefully in
the same format/layout every time) which contains information relating to
customer visits. The information will extend across to column K and down
through a varying number of rows.
My task each week will be to identify the following:
- any new rows that have been added since the previous document
- any rows whereby the information has changed, i.e. the date of the next
visit might change therefore the existing information will have been amended
Is there any easy way to do this each time? Any help would be appreciated.
|