VBA Excel File Compare

Job ID: 34265390

Budget: $30 – $250 USD

I need a VBA Excel script that I can run on demand that will compare two excel files (around 150k rows -script needs to be dynamically determine the number of rows & columns) and report on differences in the two files. There will be unique data in column A for each product. I need the output to tell me columns that are additions from one file to the next, deletions from one file to the next and most importantly data that changes within the columns from one file to the next. The changes I would like to have highlighted but all of the columns listed. I would like to have the 3 types of data Additions, Deletions and Changes each put into separate tabs named Add, Delete, Change.