Might be a stupid question, might not be possible... I dunno, but maybe someone knows how to make it happen

I have a list of about 4300 rows of data, each an individual person (membership list)... I want there to be a page break between the letters of last names...

I.E. The names are entered in the first cell as "John Doe"... I want the page to break at the end of the last names that start with D so I can print the list and separate the print out by letters of the last name.

Can this be done - or is there another way I'm just unaware of?

Thanks for the help

7/13/2007 4:07:18 PM

not automagically i dont think....

what version of excel?

you want "page break preview" under the view tab i think.... then just move the blue lines

7/13/2007 4:20:37 PM

wow, disregard my previous post.

some info is needed. do any of the name cells contain middle names?

it won't be automatic, but it won't be horrible

[Edited on July 13, 2007 at 7:07 PM. Reason : .]

7/13/2007 6:54:12 PM

no middle names... some may have two first names, but not often

I think it's 2000

[Edited on July 13, 2007 at 7:25 PM. Reason : ...]

7/13/2007 7:23:50 PM

couldnt you just put the excel info in a database and sort by letter?

7/13/2007 7:34:29 PM

okay do this then:

select the whole column of names.
go to data > text to columns
select delimited
hit next
select space
hit next
hit finish
now go through and delete the double first names from the list so that there is a "first" and "last" column

then autofilter your sheet
press the down arrow next to the "last" column
hit "custom" from the dropdown
select "begins with"
enter "A" into the text box
press OK
print the resulting list
change "A" to "B" and repeat for each letter


if this is a static list then just sort by the "last" column and drag the page breaks to the letter breaks. if its a constantly updated list then do the above.

^excel can sort, no need for a database, however the problem comes in that the names aren't Last, First

[Edited on July 13, 2007 at 7:41 PM. Reason : .]

7/13/2007 7:39:05 PM

Thanks! I'm going to try it Monday and see how it goes

7/14/2007 2:02:54 PM