I have some excel files that have need to be processed using a script. The spreadsheets have several columns. One column is an email address column. I need a script that will look through the email address column of one spreadsheet and remove rows contain those addresses in the second spreadsheet. There are a couple of other functions need as well. For example comparing 2 files to file duplicate records. And also when there is a duplicate deciding which record to pull based on certain criteria.
Although these files are currently excel files I would be happy to upload them to a mysql table. The script could then be processed via PHP. Please tell me in your bid wish way you wish to process the data (VBScript or PHP). I would prefer VBScript. My budget is $30.