I have some data in that spaces two sets of rows like

asdfkklj
asdjfkh
jdhf
akfh


akshf
asdfkjh
asfkjh
asdfljkh

and I would like to scale the first one to fit one page and the second one to print a page. Obviously I could copy the data to another sheet and print from there using scale to fit. Is there any way to do this directly and unobtrusivly? (using a macro would work as it could get the block of data then copy it to a new sheet, print, then repeat for next block. The data is very similar and repetitive)