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!


--
bucknekkid
------------------------------------------------------------------------
bucknekkid's Profile: http://www.excelforum.com/member.php...o&userid=24204
View this thread: http://www.excelforum.com/showthread...hreadid=378167