Hi,
I have an excel list of 750 family addresses that a charity will be delivering Thanksgiving dinners to. I need to hand a page of 5 families to 150 different drivers.
Is there a way to automatically print rows 1-5 on one page, then 6-10 on the next page etc. until all 750 families are printed?
You could adjust the bottom margin so it breaks that way.
Entia non sunt multiplicanda sine necessitate
Thanks for suggestions.
That works. Trouble is that some of the address lines have a large amount of text describing the family. So some pages show 2 families on a page some 5 while using this page margin method.
If there are other suggestions on keeping 5 rows per page would love to know.
assuming no header row
will set the page breaks every 5th row
Please Login or Register to view this content.
no guarantee it works adapted from my archived code snippets but looks ok on a book i set up
Last edited by martindwilson; 11-16-2013 at 03:31 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Go, Martin
Thank you, I'm excited to try! Will this work on a Mac and if so do you know instructions on how to use the code, or should I find a PC...
no idea about mac! sorry
Works great thank you!
Was able to do this on the Mac also. Tools > Macros > Visual Basic Editor > Paste > Run
Also here's another set of code.
Sub formatSheets()
For i = 5 To 750 Step 5
ActiveSheet.HPageBreaks.Add Before:=Cells(i + 1, 1)
Next
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks