so i have a formula that wont work in my macro but if i cut and paste it into the cell i want it to work in, it works fine....
Range("B2").Formula = "=IF(ISERROR(IF(MATCH(Courses!A1,Master!B1:B700),Courses!A1,"")),"",IF(MATCH(Courses!A1,Master!B1:B700),Courses!A1,""))"
this one works and its the same format ....
Range("C2").Formula = "=IF(SUMPRODUCT(--(Updated!$A$1:$A$700=$A$1)*--(Updated!$B$1:$B$700=B2),Updated!$E$1:$E$700),SUMPRODUCT(--(Updated!$A$1:$A$700=$A$1)*--(Updated!$B$1:$B$700=B2),Updated!$E$1:$E$700),(SUMPRODUCT(--(Master!$A$1:$A$700=$A$1)*--(Master!$B$1:$B$700=B2),Master!$C$1:$C$700)))"
what am i doing wrong? dont worry about the second formula, it works fine but the first one is giving me issues only in my macro .. the only other difference and i dont know if it matters or not but b2 is text and c2 is a number
Courses!A1 contains a course name that needs to be found on the master sheet anywhere in b1:b700 if its not there it puts a blank cell...and theres no space on courses!a1 if its showing up that way .. :-)
Bookmarks