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