Please search this or almost any other Excel group at
http://www.google.com/grphp for an answer which has been provided hundreds
if not thousands of times before. Some new functionality was introduced in
XP, but there is no way to link headers with the main sheet in Excel2k or
previous.

Paul C,

Paul, as stated if you do a search will should fine many ways, but here is
one to do it for you before you print the sheet

Private Sub Workbook_BeforePrint(Cancel As Boolean)
'put in worksheet code, will put what's in A1 in the right header
ActiveSheet.PageSetup.RightHeader = Range("A1")
End Sub