Thread: Can Excel headers automatically look to a cell for data? &[B2]
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bailey bailey is offline
external usenet poster
  
Posts: 22
Default 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?



Reply With QuoteReply With Quote