I need Information in a single column to appear as different Header on each page.

[nmerrick]

Hi, I'm working on a simple spreadsheet with individuals divided among teams. Each team is separated by a page break, so the column displaying Team Name repeats the same team name all down a page, and then another team name all down the next page, and so on. I've been searching for a way to display one instance of each Team Name as the Page Header (or just at the top of each page) upon printing. I've included an attachment for reference. PLEASE ADVISE!! Thank you!

[BigBas]

Probably the easiest option is to develop a conditional format rule to change the font color of all occurrences of a team name after the first. To do so, follow the steps below:

1. Highlight the range containing the team names. In your case, highlight range A2:A791
2. In the Home tab of the Excel Ribbon, select Conditional Format, then click 'New Rule
3. In the dialog box, select 'Use a formula to determine which cells to format' (This is the last selection option)
4. Enter the formula EXACTLY as it is here: =COUNTIF($A$2:A2,A2)>1
5. Click on the Format button, select the Font tab, and in the Color dropdown box, select White

Take a look at the results and see if it suits your needs

[nmerrick]

That is clever! and helpful! But is there a formula I could use to make those cells appear at the top of their respective pages? Ideally, I'd like to do that and then hide the Team column altogether.

[AB33]

Are you looking for a formula, or a code?

[nmerrick]

Are you looking for a formula, or a code?

i don't think i would know what to do with code. whatever accomplishes the task really. thanks!

[AB33]

Please do not reply with quote. Just a reply will do.
I was looking this thread on the other section and you had received a macro solution. You now re-posted it to this section.
I have a code solution, but I would like to know first why can not use the code you have.
I do not think it is possible with a formula.
As you know, worksheet names could not be longer than 32 chr and should not contain chr like/,\ . On some lines of your sheet, you have this issue. I think(Rows 111-121) names are longer than 32 chr, so you either cut them to less than 32chr, or the code will not create tabs for these rows.