@
Saraah
Your previous timing was 2-3 secs, now You wrote that You'll use 4-5 secs.
Why You asked to make date checking at all and before that 'ROB'?
Why You don't use the original file at once? Rename it!
'Record timing' ...
Many people just say that they can do something in 1 minute.
But, then someone asks to to do it now, just now!
They say ... no no no or if they start it, it takes 15 minutes or what ever.
You wrote that You could do this quicker than 3 minutes ... but You cannot!
Of course, if You skip some parts of jobs that You asked (like checking dates ~20'000 rows) You could do it faster. Remember that is .cvs-file.
You asked to check dates (+'ROB') and copy - NOT just copy!
So copy that file with out open it! and after that Rename.
That would be the quickest method!