Excel filter with macro

Hello,


I have a excel with different criteria , in which i have to filter according to three criteria's .

* And finally i have to pick a cell & divide the amount equally with the below cells .
can anyone help me in this case with a macro .

thanks in advance .

cheers

Steve