Page Break

[Greg Malenky]

Excel 2000

I'm creating a excel worksheet that has several
categories and sub-categories. each category and sub-
category have different count totals.

for example the categories might be first thru eighth
graders and the sub-categories would be boys and girls.

first grade - boys - tom
jim
billy
girls - tina
jennifer
second grade - boys - joe
john
girls - kim
tammy
michelle

What I want is to create a new page for each category.
Now the category and sub-category information works out
to two columns each and some will need more than one page
for each category.

 

[Dave Peterson]

Does new page mean new printed page?

If yes, then I would fill those categories (first grade on each row that needs
it).

Debra Dalgleish has instructions for filling those cells:
http://www.contextures.com/xlDataEntry02.html

And she shows how to make them look empty using conditional formatting (white
font on a white background):
http://www.contextures.com/xlCondFormat03.html#Duplicate

Then you can use
Data|subtotals to get new pages between groups.
(There's an option at the bottom of that dialog.)

If you meant different worksheets, I'd still fill those empty cells using Deb's
techniques, but then I'd use some code from here site:

http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb


==========
In reality, I wouldn't put them on new sheets. I'd fill those empty cells, but
then I'd apply data|filter|autofilter and just show the ones I want.