please help me - page break
If you change your requirements, you may find that the tools built into excel
are sufficient--and easier to use.
If you clean up your data--only a header row and the actual data (no subtotals,
no empty rows), then you could:
select the range (header row to bottom of data and all the columns you need)
Sort your data by the category field (the field that contains 915).
Then data|subtotals (in xl2003 menus)
One of the options is to add page breaks between groups.
yepidu wrote:
915 441722 COTTRELL, ERIN M
915 Total
922 155872 SABIN, DEAN
I need to insert a page break after 915 Total, but leave the blank line
above 922.
--
yepidu
--
Dave Peterson
|