Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want to print postcards multiple up on a sheet with mail merge. Say
there are 200 postcards and 4 up on a sheet. Instead of having the list sorted so that records 1-4 are on the first sheet, 5-8 on the second sheet and so on, I want to sort down through the stack so that record #1 will be on the first sheet, top left position, record #2 will be on the second sheet, top left position, record #3 will be on the 3rd sheet top left position and so on. This means then that record #s 1, 51, 101 and 151 will all be on the first sheet, records 2, 52, 102 and 152 will be on the 2nd sheet, etc. The catch is that I want the number of sheets to be a variable as well as the number of postcards on a sheet so that if I decide I want to do 275 postcards with 6 postcards on a sheet, all I have to do is change the #up and #sheets variable and the record numbers will update accordingly. Seems pretty simple, and I got it to work with a +4 of the previous cell except that if I change the # up or # of postcards I have to manually update the cells and this defeats the purpose, especially if I want to do 1000+ records. Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combining Excel mailing lists | Excel Discussion (Misc queries) | |||
How do I compare two mailing lists. One Sent and one not sent? | Excel Worksheet Functions | |||
need help sorting records over multiple worksheets | Excel Discussion (Misc queries) | |||
How do I compare customer mailing lists? | Excel Worksheet Functions | |||
Compare records in multiple sheet -> report | Excel Discussion (Misc queries) |