Can Excel headers automatically look to a cell for data? &[B2]
 

Using MS Office Excel 2003 SP2. Created a crew calender that shows each
week's crew schedule on a seperate tab. Each worksheet shows days Sunday
through Saturday as the column's top cell. The date is shown in the second
cell of each column. I wanted Sunday's date to show in the header for each
sheet that is printed out. I tried &[B2]. Is what I'm attempting even
possible?

Can Excel headers automatically look to a cell for data? &[B2]
 

Possible through VBA

Sub CellInFooter()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Sheets
ws.PageSetup.CenterFooter = ws.Range("A2").Value
Next
End Sub


Gord Dibben MS Excel MVP

On Sun, 7 Jan 2007 13:43:01 -0800, bailey
wrote:

Using MS Office Excel 2003 SP2. Created a crew calender that shows each
week's crew schedule on a seperate tab. Each worksheet shows days Sunday
through Saturday as the column's top cell. The date is shown in the second
cell of each column. I wanted Sunday's date to show in the header for each
sheet that is printed out. I tried &[B2]. Is what I'm attempting even
possible?