I've got a macro which returns the names of all the files within a folder into sheet 2. In sheet 1 is the names of the original files in that folder. All the file names have a standardized file name structure (e.g. 123456-Test-Exp-V1). I need a macro that will identify the latest file names. For instance 123456-Test-Exp-V1 may be in sheet 1 but if the macro returns 123456-Test-Exp-V2 in sheet 2 then I need the record in sheet 1 to be replaced by this new version. Also if no matching record is found I need those file names to be put into a new row in sheet 1.
I really hope this makes sense. I appreciate any suggestion on this topic.