![]() |
formula for sorting mailing lists for multiple records per sheet
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! |
All times are GMT +1. The time now is 01:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com