title: Most efficient way of offseting cell that contains "x"
body: <p>I've been using <code>Columns(2).Copy Destination:=Columns(1)</code> provisionally to offset all cells that contain "x" one column to the left, however it seems to be very memory consuming and not very reliable as I can't choose to offset only "x" values.</p>
  
  <p>Is there any way I can make only the cells on which this contition was met to be offset, and on a more efficient way?</p>