Duplicate sheet when overflowing rows

**MartinGTC** · 10-24-2013, 03:41 AM

Morning all,

We are currently in the process of having a system makeover, with some documents written in Word, as the lines add up, if it fills the page and jumps onto a second (from a template) the document replicates the layout (almost like a master) and additional lines are added onto a second page.

We have moved some onto excel for formulas and general layouts which seem easier - but is there a way to do the above in Excel? for instance, if I have 50 rows on 1 page and need to include 75 for instance, I need to copy the entire layout and have page 2 show 51-75.

I hope this makes sense and look forwards to your genius responses! (please avoid macros/VB as I know NOTHING about that :P )

**:) Sixthsense :)** · 10-24-2013, 03:58 AM

Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).

**MartinGTC** · 10-24-2013, 04:12 AM

Thanks,

I've attached 2 worksheets - Order1 shows with rows 1-21 which would print on 1 sheet if data is between these - i.e, if we list 10 things, it will fit on one sheet (the bottom sections/top need to stay as they are), but if data needs to go into a 22nd cell or more, the sheet is duplicated and these rows filled along with the first sheet.

I hope this is clear, let me know if not