| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel automatically insert current date in a cell? | Excel Worksheet Functions | |||
| Cell References | Excel Discussion (Misc queries) | |||
| input 7 in a cell in EXCEL 2000, it will automatically change to 8 | Excel Discussion (Misc queries) | |||
| how do i get excel to automatically compute cell values | Excel Discussion (Misc queries) | |||
| In excel, can I format a cell to automatically take the curser to. | Excel Worksheet Functions | |||
Linear Mode
