title: Copy data from one cell to a cell in another sheet based on the value of a second cell in the first sheet?
body: <p>I am trying to copy the value of a cell in one sheet to a cell in another sheet based on the value of a third cell ('yes' or blank).
  Example:</p>
  
  <pre><code>Cell A1: Monday
  Cell B1: Yes
  </code></pre>
  
  <p>Copy the value of Cell <code>A1</code> into sheet2 Cell <code>B5</code> if <code>B1 = Yes</code>. If cell <code>B2</code> is empty (or 'No') do nothing. Is this possible?<br>
  I was trying to do it by using if statement but not having any luck. </p>
  
  <p>[EDIT] Here is my code (but it doesn't work yet):</p>
  
  <pre><code>Sub ColorWhite()
  Range("B01:B15").Value = Yes
  
  With Selection.Font
      .ThemeColor = x1ThemeColorDark1
      .TintAndShade = 0
  End
  
  Range("B01:B15").Value Not Yes
  Selection.EntireRow.Hidden = True
  
  End Sub
  </code></pre>