I have an excel file for which I get an update every week.
The layout is the same and I want to compare the old and new file by order number, start date and end date.
Rows that have remained the same can remain in the old file.
I only want to keep the rows from the new list that are different from the old file or that are new
Can someone help me to some formula or VBA code to do this, example in the picture below.
The layout is the same and I want to compare the old and new file by order number, start date and end date.
Rows that have remained the same can remain in the old file.
I only want to keep the rows from the new list that are different from the old file or that are new
Can someone help me to some formula or VBA code to do this, example in the picture below.