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
Bookmarks