I need a script to compare rows of results that can auto de-dupe via .VBS script for automation purposes
Posted on 2008-10-24
I am in the midst of seeking a script that can take a spread sheet in a given directory, open it, and check all the rows top heading down. I would want the code to specify if there are exact matches to remove them on all worksheets (not just the active one) and then save the file as deduped.myfile.xls instead of over writting the original file.
Thanks for your help in advance!