In a previous question, Ejgil Hedegaard provided the attached solution.
The code in the "Destination -Workbook1.xls" file opens another workbook "testdata.xls" sheet1, copies all rows from the source where the date in column A of the source is greater than the latest (max) date in Column A sheet "Raw Data" of the destination (starting with the next blank row of any existing data)
This works quickly and efficiently, however, occasionally lines with a date earlier than the max date (a new date entirely) exist in the source (due to a data anomaly) but not the destination because the code only looks for rows with a date in column A of the source that is later than the max date in the destination.
In the attached example the destination is missing the rows with the date 1/22/2015 and 1/25/2015 in column A. Running the code copies over 1/25/2015 but not 1/22/2015 since the max date in the destination is 1/24/2015.
The solution to this problem would also get 1/22/2015.
The number of lines for any given date will never change so the code does not need to check if there are any more rows for a date that has already been copied over.
Hope I explained this clearly,
Thanks in advance,