Auto Populate Header Using Another Sheet

mschonefeld 

This requires VBA. For example in the Worksheet_Activate event:

• Right-click the sheet tab of sheet B.
• Select 'View Code' from the context menu.
• Copy the code listed below into the worksheet module.
• Switch back to Excel and save the workbook.
• The header will be updated when you activate sheet B.

Private Sub Worksheet_Activate()
    Me.PageSetup.CenterHeader = _
        "&""Arial""&14&B" & _
        Worksheets("A").Range("H6").Value & vbLf & _
        "PO #" & Worksheets("A").Range("C6").Value & vbLf & vbLf & _
        "PRELIMINARY" & vbLf & vbLf & _
        "COLOR SAMPLE REQUEST"
End Sub