Need an Autofill VBA

[mrprofit]

thank you, G5 in sheet3 is empty when i apply the vba, G5 value 101.766, and E6:F9 has 0 value in it, and possible to keep the formula in the cells?

[LalitPandey87]

Are you asking to apply formula using vba or somthing else.
If you want formula then why need VBA just put formula and drag it till the end and whenever you put value, it will show you the output values

[mrprofit]

usig this VBA is fine, may be keep the formula in row 2 in case in future i need the formula,