Speed up calculation

[guatelize]

I have some problems with excel. It takes so much time to calculate a large number of data, maybe you can help me.
In the attached file I have formulas with defined name fields. Is it possible to convert them into a macro. It has to meet a condition : when columnA to column S has data, these formulas have to calculate until last not empty cell in the sheet.
Thank you very much

[f2e4]

Have you tried just recording the formulas in a macro or creating your own module

Example:


Sub Calc_Sheet1 ()

Range("T2").formula = "=SUMPRODUCT(--(BMPartner=P2),--(BMProduct=O2),--(BMProdDescr=Q2),--(BMLOCATION=R2),--(BMMOT=S2),--(BMQTY))"

End Sub


Is this the kind of code you are looking for or is it something else?

[Bob Phillips]

That workbook is not that helpful, it is dotted with #NAME errors, and there is little data we can check success against.