Adding a formula to a header is it possible?

[anill]

Hi,
I am doing a roster for shift work in a hospital. I have the date, type of shift as the columns. Each page has the roster for a month. I want the Month to appear as the header on each page. eg page 2 is November and I want the header to appear as Roster for November. Is this possible? Thanks in advance to all who are willing to help.
Regards
Dr AP

 

[tactps]

If each page is on a different sheet then:
The easy way is to name the page "Roster for November". Then in the header, choose the name from the drop-down list.

If they are on the same sheet, try this:
Sub Macro1()
StartPrint = "A2"
Range("A3").Select
ActiveSheet.ResetAllPageBreaks
MonthRef = Month(ActiveCell)
MonthRef1 = Format(ActiveCell, "mmmm")
With ActiveSheet.PageSetup
.CenterHeader = "Roster for " & MonthRef1
End With
Do Until ActiveCell.Text = ""
MonthRef = Month(ActiveCell)
MonthRef1 = Format(ActiveCell, "mmmm")
If Month(ActiveCell.Offset(-1, 0)) = MonthRef Then
Else
EndPrint = ActiveCell.Offset(-1, 2).Address
Range(StartPrint & ":" & EndPrint).PrintOut
StartPrint = ActiveCell.Offset(1, 0).Address
End If
ActiveCell.Offset(1, 0).Select
Loop
StartPrint = ActiveCell.Offset(-3, 0).Address
With ActiveSheet.PageSetup
.CenterHeader = "Roster for " & MonthRef1
End With
EndPrint = ActiveCell.Offset(0, 2).Address
Range(StartPrint & ":" & EndPrint).PrintOut
End Sub

 

[2rrs]

One way;
Name the sheet "Roster for November"
Then use custom header and select "Tab"

Hi,
I am doing a roster for shift work in a hospital. I have the date, type of shift as the columns. Each page has the roster for a month. I want the Month to appear as the header on each page. eg page 2 is November and I want the header to appear as Roster for November. Is this possible? Thanks in advance to all who are willing to help.
Regards
Dr AP

 

[anill]

Hi,
Thank you for your reply, very much appreciated. I will try and put the monthly rota into individual sheets. The other solution must be a macro / vba which I know nothing about may be in a few years time I wil make more sense of it.
Dr AP