vba to fill data automatically

[SP2911]

Hi all,
I have two sheets in workbook,
In sheet 1 there is data in col. A,B,C and based on this data there is Formula in Sheet 2 in Col. A,B,C.
My issue is If I add data in sheet 1 , I have to drag the formula , so I need VBA to automatically drag the formula.
I have attached sheet herewith

 

[Marc L]

Hi !

As you created same thread before on another forum,
please read both forum rules, no wild cross posting allowed, thanks !

No need a code just using tables at least …
​