VBA for Compare Contrast a Large about of Data

[QuenH]

Hi,

I've trying to figure out out to write a VBA for a large about of information. I'm using two sources I pull into there own sheet, a matrix and reports. On a separate sheet I pull in data to two columns. A third column is a formula if each equal the same then "yes" if not "no". The problem is it is a mass about of information and can freeze up Excel. I'd like to write a VBA so Excel isn't loaded down with formulas to consolidate this information.
Column 1 : =IFERROR(VLOOKUP(A:A,Matrix!A:J,2,FALSE),0)

Column 2 : =IFERROR(LOOKUP(2,1/(Report!A:A=A2099)/(Report!D:D=$B$1),(Report!M:M)),0)

Coulmn 3 : =IF(B2099=C2099,"Yes","No")

Multiply these three columns by 20 and over 2000 rows.

Any ideas for a VBA for this please let me know. I'm still a little new to VBAs.

 

[mumps]

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your 3 sheets. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).