Changing headers without macros or VB
 

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
--
If you don''''t like technology, you should be living naked, in a dark cave,
eating the raw fish that you caught by hand.

Changing headers without macros or VB
 

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

-Chad

"Stuart Mantel" wrote:

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
--
If you don''''t like technology, you should be living naked, in a dark cave,
eating the raw fish that you caught by hand.

Changing headers without macros or VB
 

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


--
If you don''''t like technology, you should be living naked, in a dark cave,
eating the raw fish that you caught by hand.


"Chad" wrote:

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

-Chad

"Stuart Mantel" wrote:

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
--
If you don''''t like technology, you should be living naked, in a dark cave,
eating the raw fish that you caught by hand.