title: Excel VBA - Copy specific cells to a new sheet with double click, in next free row
body: <p>I'm trying these days to make the following task:</p>
  <p>I have a sheet which is something like a touchscreen Offer . I call it Sheet &quot;NewOffer&quot;.
  Inside this sheet there is a range of cells J7 to L27 inside which dynamically appear results (products).</p>
  <p>What i want is to copy (with double click) the specific range, lets say J7 to L7 when i double click the first cell (J7).
  and etc if i double click for example J9 to copy J9 to L9 and copy the row - range results in a new Sheet lets call it &quot;NewOrders&quot; in A2 to C2 cells and the next available row if its occupied.</p>
  <p>I would ideally like to copy only the values and not the borders, colors etc..
  (Sorry for my bad English :) )</p>
  <p>Any help ?</p>