worker101010
05-21-2019, 07:16 AM
Hello,
I am currently in need of a VBA code that will be able to detect if there are duplicate cells in two columns of data within two worksheets of two different workbooks. I need the code to display a message box (i.e. "there are duplicates present") if the information is found. One column of data is going to be substantially longer than the other. Need the code to go one by one through the Eval worksheet and compare each value in column F to the 200+ entries in column F of the other worksheet to see if the value has a duplicate.
Any guidance/help would be greatly appreciated. I can provide more information if needed.
Thank you!
I am currently in need of a VBA code that will be able to detect if there are duplicate cells in two columns of data within two worksheets of two different workbooks. I need the code to display a message box (i.e. "there are duplicates present") if the information is found. One column of data is going to be substantially longer than the other. Need the code to go one by one through the Eval worksheet and compare each value in column F to the 200+ entries in column F of the other worksheet to see if the value has a duplicate.
Any guidance/help would be greatly appreciated. I can provide more information if needed.
Thank you!