title: Copy and Paste to next available column
body: <p>I'm trying to track weekly quantities I have in my spread sheet. So far I've made a macro to copy and paste the info where I need it. But it will only paste it to the spot I chose while recording the macro. I'd like it to paste the info into the next available column.</p>
  
  <p>I'd also like to schedule the macro to run once a week on Friday morning.</p>
  
  <p>Macro I'm using now.</p>
  
  <pre><code>Sub CopyPaste()
  '
  ' CopyPaste Macro
  '
  
  '
     Range("G4:G33").Select
     Selection.Copy
     Range("B35").Select
     Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
      :=False, Transpose:=False
  End Sub
  </code></pre>
  
  <p>I've tried putting &amp; lastrow into the range, but it gets a compile error. Any help would be greatly appreciated.</p>