vba to Replace Old values by new values depends upon cell values in AC:AC col

Dear experts

I have some data values in multiple column i want replace the old values depends upon cell value in AC:AC
I tried some vba code..but it doesnt work for me.. i need ur help

If Crm_Labor_Item_Status Is Cancelled 1. Then Re-Place Old Values By "Cancel" In Activecalls Cells (Ah:Ah) Then 2. Re-Place Old Values By "Tata" In Action Owner (Al:Al)Then 3. Re-Place Old Values By "Cancel In Cci Portal" In Status (Am:Am)

If Crm_Labor_Item_Status Is Closed Then 1. Re-Place Old Values By "Closed" In Activecalls Cells (Ah:Ah) Then 2. Re-Place Old Values By "Tata" In Action Owner (Al:Al) Then 3.Re-Place Old Values By "Closed/Completed In Cci Portal" In Status (Am:Am)

If Crm_Labor_Item_Status Is Complete Then 1. Re-Place Old Values By "Closed" In Activecalls Cells (Ah:Ah) Then 2.Re-Place Old Values By "Tata" In Action Owner (Al:Al) Then 3.Re-Place Old Values By "Closed/Completed In Cci Portal" In Status (Am:Am)

find the attachment & code

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Wow Sir code works perfectly!!! Thanks Alot

You're welcome. Glad to help out and thanks for the feedback. Please mark this thread as solved.