title: get two cells to print from same page
body: <p>I was wondering if its possible to have a macro that populates a page and prints it then goes to the next one from the column and so on.</p>
  
  <p>The number would go on Sheet2, C2 and name on C4. this is a template so it should delete empty and then refresh the next number and name from the list in sheet1.</p>
  
  <p>The only thing is could it be set so I can select the starting cell or does it have to print all in the row at once? Say I only wanted to print 20 today then another 50 tomorrow can that be done....</p>
  
  <p>Its a lot of manual typing at the moment so any help would be great.</p>
  
  <p>I have an example below (names changed) that the column could have up to 500 names that need to be printed to place in each folder. Below put the number in correctly I just cant work out how to also include the name from cell D2 in sheet1</p>
  
  <pre><code>Sub PrintLoop()
      Dim c As Range, LR As Long
      Application.ScreenUpdating = False
      LR = Sheets("sheet1").Range("C" &amp; Rows.Count).End(xlUp).Row
      For Each c In Sheets("sheet1").Range("C2:C" &amp; LR)
          Sheets("sheet2").Range("C2").Value = c.Value
          Sheets("sheet2").PrintPreview
      Next c
      Application.ScreenUpdating = True
  End Sub
  </code></pre>