Hello there,

I'm having trouble trying to find a way to copy some rows in my worksheet. Here's the scenario.

I've got an invoice sheet set up which takes up 50 rows, and since I need several pages sometimes to include all the items, I want be able to specify the number of pages by inputing a number in a cell. For instance, typing in "3" will give me 3 pages, automatically (without me having to copy and paste the 50 rows manually). The 50 rows would be pasted right under one another within the same worksheet. I was thinking of something that uses a loop to copy the contents from another sheet.

I'm a newb at this, so any help would be very much appreciated. Thanks!