Hello been a while for me.

What I want to do Is print sheet multiple sheets after, The sheet is updated by new row fromunscreenedPatients then advances 1 row and starts over

Sheet2 is populated from sheet1 then needs printed.


I need to start from Cell A2 from unscreenedPatients andcontinue on for a set number (say 50).

I need the sheet to increase 1 row fill in sheet2 print;fill in sheet2 from next row in unscreenedPatients and continue on.

Would like a way to control start line and end line as I can’t print 2500sheets at a time, nor would I want to.

If not able to set number of lines to print I could deletethe lines I print and then use macro again later.

Any help greatly appreciated.
Thanks