jmendenhall1960
New Member
- Joined
- Feb 14, 2012
- Messages
- 41
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
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