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