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?
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?