PDA

View Full Version : Comparison between two worksheets and find the difference



vincentzack
07-25-2016, 05:52 AM
As the title says I need to compare two worksheets and find the difference. The worksheets contain about 2000 nos of rows. I need compare column A to T of sheet1 and that of sheet2 and list the difference in sheet3. The mark in sheet3 (column A) is copied from sheet1 Column A).

I extracted some of the data for testing. Can someone please help me how to create a VBA Program to Compare 20 Columns in Excel and store the difference in sheet3? Is it using "Scripting Dictionary" much faster?

vincentzack
07-26-2016, 07:15 AM
I found a excel from internet. Will it help to write the code as I need?

http://www.ozgrid.com/forum/showthread.php?t=174992