title: How to use copy value for some cells when a change the value with a list in another cell using VBA?
body: <p>When i change the value of column H from ESTOQUE to VENDAS i want the respective line (Range C4:G4) to be paste with its current value and no longer the equation that made the values. This table has hudred of cells so a want to do it automatomaticaly for each line i change the cell to &quot;Vendas&quot;.</p>
  <p><a href="https://i.stack.imgur.com/AumNV.png" rel="nofollow noreferrer">enter image description here</a></p>