Hello,

I have two columns A and B. Column A is "CustomerStatus" and Column B is "AccountStatus". I would like to have some VBA code that automatically enters the word "Inactive" in B2 (AccountStatus) if A2 (CustomerStatus) also = "Inactive." Preferably not in a button or macro that I run, just as soon as any value in Column A changes to "Inactive".

Any help?