Changing headers without macros or VB

[Guest]

I am setting up an Excel sheet to track inventory. Is there a way to change
the line that prints on the top of the sheet (below the header) based on a
set of criteria?

The sheet has Catagory 1, Catagory 2, Catagory 3, etc. Each Catagory starts
on a fresh page. I would like to have the catagory display at the top of the
appripriate page under the header.

Security concerns prevent the use of VB or macros. The worksheet is
distributed via e-mail and scripts are blocked on some servers/clients.

I can't use seperate worksheet tabs, "It gets too confusing" (their words
not mine).

Sorry for the length.

Thanks,
Stuart

 

[Guest]

Try "row to repeat at top" under page setup on the sheet tab.

-Chad

 

[Guest]

Thanks for the reply. Maybe I wasn't clear.



On this sheet, "Catagory 1" is on row 3, "Catagory 2" starts after row 124,
"Catagory 3" starts after row 290.

"row repeat" will only repeat the "Catagory 1" header. I would like it to
change appropriately.

Thanks again,
Stuart