Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can cells be referenced from a header? (Excel 97)

    Hi All,

    Please forgive my naivete, but I don't know a heck of a lot about Excel (but I'm learning all the time!).

    Is there any way to reference cells from a worksheet in a header? I want my header to contain specific information that is contained on a separate sheet.

    I tried title rows, but the problem is that my worksheet contains a whole lot of columns, and it won't repeat the title on each page because there is no title above my other columns.

    Any ideas would be most welcome.

    Cecilia :-)
    Moving from Access to Excel in slow leaps & bounds *g*

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can cells be referenced from a header? (Excel 97)

    No, you can not directly reference a cell in a header or footer. You basically have two choices to do what you want to do:

    1- Put an empty row or rows at the top of your worksheet and reference the cells in the cells of that row or rows. Then use the page setup/sheet tab to tell XL to repeat those rows at the top of every page.

    2- Use an event routine like BeforePrint to move the data from the cells to the header or footer. See This Thread for and example of how to put a date from a cell into the header.
    Legare Coleman

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Can cells be referenced from a header? (Excel 97)

    To put the contents of cell A1 into a worksheet
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can cells be referenced from a header? (Excel 97)

    Hi!

    The issue with the sheet tab is this: My report contains five rows at the top that have a top header, and the first two columns on the left are the left hand header. Then I have about 30 columns going across the page.

    When I print the sheet, I want each sheet to have the top header and the left header. But since the top header only occurs above the first few columns, it doesn't repeat itself across the pages.

    Thanks for the reference, part of the struggle here is that I'm not even sure what I should be looking for!

    Cecilia :-)

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can cells be referenced from a header? (Excel 97)

    This looks cool! I'm going to play with it, but I think between your example and the reference above, I've got it!

    Thanks!

    Cecilia :-)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •