comparision between two excel sheet using VBA Code for Index/match/and/iferror formula

Hello Friends,

I am developing on excel workbook which has two worksheets,

I am refering "W36_2012" as a refrence and "W45_2012" as a current sheet. I have several excel formula but I want to develop marco base file.

can any one help me to develop this macro.

formuals on "W45_2012" are as follow:

=IFERROR(IF(AND(INDEX(W36_2012!R:R;MATCH($H15;W36_2012!H:H;0))<>"Rejected";$R15="Rejected");"Test Rejected";"Test Maintained");"Test Added")

=IFERROR(IF($GL15="Test Rejected";IF(INDEX(W36_2012!$EB:$EB;MATCH($H15;W36_2012!$H:$H;0))="";0;-INDEX(W36_2012!$EB:$EB;MATCH($H15;W36_2012!$H:$H;0)));IFERROR($EB15-INDEX(W36_2012!$EB:$EB;MATCH($H15;W36_2012!$H:$H;0));IF($EB15<>"";$EB15;0)));0)

=IF($GL15="Test Rejected";"Test Rejected";IF($R15="Rejected"; "N/A";IF($GL15="Test Maintained";IF(GM15<>0;IF(GM15>0;"Forecast increased";"Forecast decreased");"No change");"New test")))

please find detail explaination in attached sheet..!

Thank you very much for help me !!

Gaurang MEHTA