extending macro to auto populate the specific cells

[Avinash Kumar]

Hi,

I have a code for one of the scenarios. Now, I need to addup another scenario to the existing one.

When the column L is populated as per the written code, then based on the values of the Column L, the other columns from Column N to Column S Should show "INPROCESS" or "N/A".


I am able to use the macro to just populate the Column L, but unable to reach the further activity.

I am attaching the template along with the code in this thread.

Request you to review the same and send me the updated code.

Regards,
Avinash