vb script to compare data from 2 excel files and write a flag if a match is found.
I am trying to write a vb script code that will enable me to read and compare data from 2 excel files. if a matach is found i put a flag. All i need is the part where it binds to the 2 files, workbooks and worksheets. and how to do the comparison. is it like the normal boolean expressions like
if(sheet1.value = sheet2.value)
They are equal
Example of the data..
File1 File 2
Sheet1 Sheet 1
Col 2 col 6 Flag
34 45 Found a match
its something like this.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.