vba code for excel formula

Hi all,

I want vba code for my excel formulas, I attached my original sheet and I want vba code for all the formulas in it.
In my attachment yellow coloured columns contains the formulas based on its left column cell value.


Thanks in advance

Dev