title: Excel VB Macro to populate cells based on a value entered
body: <p>What I am trying to accomplish is to create a macro/VB to populate cells to the left and right of a particular cell I am entering data into.</p>
  
  <p>So, let's say I have three columns. The center column will be where I type a number of 30 or 31. If I type 30, I want the cells on the left to populate with PENDING and the cell on the right to populate with TBD. Similar function if I type 31 but will be different data.</p>
  
  <p>Any thoughts?
  Thanks</p>