title: Copy whole sheet to another VBA
body: <p>I'm looking for a vba macro that copy whole data inside a sheet to another creating the new sheet. For example; I have a sheet called <code>14.11.2013</code> with some values.. clicking a button i need that the macro creates the new sheet and copy the entire datas from <code>14.11.2013</code> sheet to this one new. I'm a beginner in vba so i don't have much idea how can i do this kind of work. Someone can help me?</p>
  
  <p>Of course when everything is copyed i want redirect in the new sheet.. I think something like:</p>
  
  <pre><code>Sheets("NewSheet").Activate
  </code></pre>