Just a thought to maybe help with your thoughts..... what if the macro would open another instance of Excel in the background/unseen, load the .csv file then compare data in it's colum D against my spreadsheet colums D and F and if it finds a match then automaticaly put a "C" in colum E then after it's finished it would close the background/unseen instance of Excel.
Bookmarks