I have two excel file like Workbook 1 and workbook 2. we download the workbook 2 file daily in my tool and need to compare the workbook 1.
if any data is missing in workbook 1, we update automatically the record in last row in workbook 1. simply said non duplicates file are add in last row .
one row has 15 columns so we add all the columns in one row but both the file has 3 columns are same .
using the 3 columns or concatenate to compare both the files and add the non duplicates in last row .
please suggest how to do that .i am the new one for vbscript