Forum Discussion
Solved
MS EXCEL VBA IF Formula.
Hi Everyone! I have a stock sheet with all models which I have already and now want to get some spcific models stock in a new sheet,,, I use =SUMPRODUCT(([@[Model No]]=RefModelsT[Model No])*RefMode...
Do you want to sum in VBA only with IF THEN ELSE END IF statement without using a standard sum formula (SUMIF, SUMIFS, SUMPRODUCT)? If so i can't help you unfortunately.
Sub MyMacro()
Dim Destws As Worksheet
Dim lastrow As Long
Set Destws = Worksheets("NewT")
lastrow = Destws.Cells(Destws.Rows.Count, "A").End(xlUp).Row
Destws.Range("C2:C" & lastrow).FormulaR1C1 = "=SUMPRODUCT(([@[Model No]]=RefModelsT[Model No])*RefModelsT[Onhand])"
End SubMaybe with these lines of code. In the attached file you can click the button in cell G2 to run the macro.