I hava a list of product codes (~15000 entries). I also have a list of files (~50000), one for each product plus some for other products. The name of each file begins with the product code.
Some of the files are missing, and obviously going through to track them down by hand is not possible. What I am trying to do is compare the list to find which products do not feature in the file list:
I need to split the list of product codes in to 2, 1 for codes that _do_ feature in the file list, and1 for codes that _don’t_ feature in the file list.
I have tried writing a macro to perform this, but my efforts have so far not produced what I need. I remember reading a possible solution to this a while ago and thought ‘that could be useful’ butobviously now I can’t find it again 🙂
Cheers,
Jamie