Hey,
This is my first post here and I apogolize already if I'm doing something wrong.
What I'm doing:
I'm copying big loads of data from place A to place B. All the data doesn't get copied (ex: file size is too big, name is too long and other problems). I need to check afterwards which files didn't get copied and copy them manually. I decided to do the checking with excel (the guy before me just checked them manually and it took hours). I export both files to excel and compare the names of the files and made a macro to do it.
The macro:
The macro compares every file name (cell) from the copied files to the original file names. Every time it finds a match, it deletes the match from the original file name list. It leaves behind none copied files. The macro works pretty well on smaller data (~1-3000) rows on both lists but when I have more rows it starts to says "Run-time error '1004': Delete method of Range class failed".
If there's an easier way to do the comparing please let me know (find duplicates doesn't work. example: if there's one file named "numbers" in the first list and 3 files with the same names (numbers) in the second list, it deletes all of them. It should delete only one since there was only one file named that way in the first list). I'm not that experienced with Excel but I'm learning. I'm using Excel2010.
All help is appreciated!
Bookmarks