Update Text based on conditions with 2 columns

[Vijayarc]

Hi Ninja Team
please help to solve my below conditions

i have attached the excel were i want to Macro to update the text comment based on condition of before 2 columns,
since there is more than 90,000 rows and data is dynamic changes on Daily basis, it is impossible to update comments manually on daily basis

i have ID - on daily basis it will move from one pillar to other , or may not move
1 LOB
2 Credit
3 Reference Data Account Closure
4 KYC
5 Reference Data to Deactivate

based on pillar movement, i want to update the comment , if moved then movement as YES otherwise NO

please help and Needful !!!

 

[Vijayarc]

Hi Ninja Team

I have done IF formula for 4 conditions, in fixed 'S' columns

please help to covert into vba code for dynamic data,

i will add one new column on daily date basis. So vba run on every last column

please Help!!

=IFERROR(IF(AND(Q33=Sheet3!$A$2,Sheet2!R33=Sheet3!$B$2),Sheet3!$C$2,IF(AND(Q33=Sheet3!$A$3,Sheet2!R33=Sheet3!$B$3),Sheet3!$C$3,IF(AND(Q33=Sheet3!$A$4,Sheet2!R33=Sheet3!$B$4),Sheet3!$C$4,IF(AND(Q33=Sheet3!$A$5,Sheet2!R33=Sheet3!$B$5),Sheet3!$C$5,"No change")))),"No Change")