Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining Excel mailing lists Art Brosius Excel Discussion (Misc queries) 0 December 29th 08 01:26 AM
How do I compare two mailing lists. One Sent and one not sent? PayPaul Excel Worksheet Functions 1 December 18th 07 04:16 PM
need help sorting records over multiple worksheets Liz Excel Discussion (Misc queries) 10 November 26th 07 09:26 AM
How do I compare customer mailing lists? Rebecca O Excel Worksheet Functions 1 October 18th 05 06:58 PM
Compare records in multiple sheet -> report PB Excel Discussion (Misc queries) 3 July 4th 05 05:16 PM


All times are GMT +1. The time now is 05:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright Đ2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"