vba code to replace old values by new value depends upon 2 col values

Dear Experts

I need vba code to replace the entire col values depends upon 2 col vlaues..

i have basic code for this condition

IF CRM_LABOR_ITEM_STATUS (AC:AC) Apart From Closed,Complete,Cancel,Select rest of all option IF Action Owner(AL:AL) is TATA Replace Old Values by "SVC" In Status Column Then Replace Old Values by "CLOSED/Completed in CCI Portal" In Remarks Column


Find the Attachment & Code basic

Please Login or Register  to view this content.

Thanks sir

In column AC:AC main constrain is Unselect three "Closed,Complete,Cancel" Then select rest of all including blank, Then
IF Action Owner(AL:AL) is TATA Replace Old Values by "SVC" In Action O Column Then Replace Old Values by "CLOSED/Completed in CCI Portal" In Status Column.

Find the attachment...