How to compare two worksheets in a single workbook

Hi All,

I have below query.
There is a workbook name ie WB1.In which there are two worksheets name as WS1 & WS2.
WS1 contain 39columns with 15,000 data and WS2 contain 44columns with 20,000 data.
Now, we want to compare two sheets data.
---------------------------------------------------------------------------------------
I have tried using collection then my bp crashed as collection can't hold that much records.
Thinking for a vlookup formula which contain every column details in one. But fail to identify.
 
Top