D
Dave
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!
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!