printing on separate pages

[tazz27]

I have a monthly logbook which keeps vendor invoice information. I would like to have excel sort the entries by vendor name and then print each vendors information on separate pages. Is there any way of doing this. Here is an example of what my worksheet looks like. I have also indicated where i would like page breaks.

VENDOR INVOICE INVOICE DATE
AMERICAN GREETINGS 020600153 6/1/2002
--break---
SHER BOOKS 2161031 6/1/2002
SHER BOOKS 2165200 6/1/2002
SHER BOOKS R728214 6/1/2002
--break---
KONICA 6215204868 6/1/2002
KONICA 6215304971 6/2/2002
--break---
DAILY NEWS 6158446 6/2/2002
--break---
MAGNIVISION 22608 6/3/2002

 

[SkipVought]

Hi, tazz,

Use the Data/Subtotals and page break between groups checkbox.

Hope this helps Skip,
SkipAndMary1017@mindspring.com