VBA for Compare Contrast a Large about of Data

QuenH

New Member
Joined
Sep 8, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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.
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

mumps

Well-known Member
Joined
Apr 11, 2012
Messages
9,949
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).
 

Watch MrExcel Video

Forum statistics

Threads
1,118,074
Messages
5,570,041
Members
412,308
Latest member
cornelb
Top