Comparing 2 datasets for reconciliation using VBA

[BigMo1987]

Hello all,

I am looking for a VBA code to reconcile two data sets in Sheet1 and Sheet2 (See attached report). Looking for qty differences between both sheets and identifying if a column A, B or C and have any discrepancies. Can anyone help?

Thank you in advance!

 

[BigMo1987]

Still crashing or (Not Responding)

I am waiting. Can you please help?

 

[Zot]

Still crashing or (Not Responding)

Can you upload sample data on cloud somewhere? I cannot create a sample that big

Logically it should not crash ... not responding, maybe but I believe it will still work in background

 

[BigMo1987]

Can you upload sample data on cloud somewhere? I cannot create a sample that big

Logically it should not crash ... not responding, maybe but I believe it will still work in background

 

[Zot]

I meant that 9000 row. This small number of rows no problem. I want to see how fast it goes through the very long list. I see other upload on cloud that it can be downloaded. You can copy paste data in blank spreadsheet if other material are confidential.

Last time a formula based llokup using VBA took more then 2 min can be reduced to less then 20 sec using other approach.

 

[BigMo1987]

I meant that 9000 row. This small number of rows no problem. I want to see how fast it goes through the very long list. I see other upload on cloud that it can be downloaded. You can copy paste data in blank spreadsheet if other material are confidential.

Last time a formula based llokup using VBA took more then 2 min can be reduced to less then 20 sec using other approach.

 

[BigMo1987]

 

[Zot]

I guess xl2bb cannot copy this big range.

You can use Drop Box or Google Drive perhaps?

 

[BigMo1987]

I guess xl2bb cannot copy this big range.

You can use Drop Box or Google Drive perhaps?

test.xlsx

Shared with Dropbox

www.dropbox.com

 

[BigMo1987]

test.xlsx

Shared with Dropbox

www.dropbox.com

Let me know if you need anything else.

 

[Zot]

Let me know if you need anything else.

I got the file. I think nothing else needed. Today I'm not free. Will have meeting whole afternoon . Hope can get something by tomorrow