title: Macro to change values of the cell range to values only
body: <p><code>A1</code> has list that includes the 12 months of the year<br>
  <code>B2</code> to <code>M2</code> row are months – Jan to Dec<br>
  <code>B3</code> to <code>B7</code> categorizes that are scored each month</p>
  
  <p>I want to program a button to do the following<br>
  When I click the button I want the macro to look up the month on cell <code>A1</code> in the cell range <code>B2:M2</code>. Then in the matching cell change the values on <code>row 3</code> to <code>row 7</code> values only. Right now <code>rows 3</code> to <code>7</code> are linked to other cells. I want them converted to values only. </p>
  
  <p>E.g. If January is selected in <code>A1</code>. Then the macro would identify <code>B2</code> as January and changes values of <code>B3:B7</code> to Values only. </p>