Hello and welcome the forum,

Simple answer is the vba. If you know the formulas then its a simple series of manipulations (e.g. insert formula --> copy results to another range, etc.). What we need from you is a dummy workbook that shows the exact structure of your current workbook, the formulas that you want to insert, and where you want the data copied, moved or inserted. A simple bullet or numbered list will suffice.

Hope this helps.

abousetta