get two cells to print from same page
===

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.
 The number would go on sheet 2 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 sheet 1.
 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....
 Its a lot of manual typing atm so any help would be great.
 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

    Sub PrintLoop()
    Dim c As Range, LR As Long
    Application.ScreenUpdating = False
    LR = Sheets("sheet1").Range("C" & Rows.Count).End(xlUp).Row
    For Each c In Sheets("sheet1").Range("C2:C" & LR)
        Sheets("sheet2").Range("C2").Value = c.Value
        Sheets("sheet2").PrintPreview
        Next c
    Application.ScreenUpdating = True
    End Sub

Marty
