View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave[_10_] Dave[_10_] is offline
external usenet poster
 
Posts: 1
Default 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!