Sorting

[Rob A]

Hi,

XP Pro

Excel '03 plus '07 beta...

I am doing a mail merge from excel. There are two pieces to a page. I need
to sort the list but when I do a two up page, page 1 has #1&#2 and so forth.
In small quantity that is not a big deal but when you do a 1000 pieces it
adds a lot of labor.

IF my list were 500 pieces, I would need to sort the spread sheet to print
page 1 to have #1&#251 then page 2 would print piece #2&#252.

Then when I cut the stack of paper, I place one half under the other they
would be in order.

Can that be done? Also for 4 pieces to a page

the sort result would look like this

2UP 4UP
1 1
251 126
2 251
252 376
3 2
253 127
4 252
254 377
5 3
255 128
6 253
256 378
7 4
257 129
8 254
258 379




Thanks in advance