title: VBA copy sheet from one workbook to another (values and format only)
body: <p>I have the following code to copy and paste one sheet from one wb to another:</p>
  
  <pre><code> wb1.Worksheets("ws").Copy After:=wb2.Sheets(wb1.Sheets.Count)
  </code></pre>
  
  <p>I'm trying to only paste values and formatting, how would I go about doing this? </p>
  
  <p>Also the process is taking a longer that expected time, possibly because the sheet I'm copying from contains a pivot table with a large amount of data. Is there anyway I can speed it up?</p>
  
  <p>Thanks for the help!</p>