Excel headers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karissa - 12 Sep 2007 20:34 GMT

I am trying to get a header in excel to reference to a cell in a different
sheet. Is that possible? Thanks!

Reply to this Message

Bernard Liengme - 12 Sep 2007 21:13 GMT

Here is some VBA that will do it:

Sub UpdateHeader()
ActiveSheet.PageSetup.LeftHeader = Range("Sheet4!G2").Value
End Sub

See:
XL2000: How to Reference a Cell in the Header or Footer
http://support.microsoft.com/default.aspx/kb/273028

If new to VBA visit David McRitchie's site on "getting started" with VBA
http://www.mvps.org/dmcritchie/excel/getstarted.htm

best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

>I am trying to get a header in excel to reference to a cell in a different
> sheet. Is that possible? Thanks!

Reply to this Message

ilia - 12 Sep 2007 21:18 GMT

> I am trying to get a header in excel to reference to a cell in a different
> sheet. Is that possible? Thanks!

Supposing the cell on a different sheet is A1 and the different sheet
itself is called Sheet2, use this formula:

='Sheet2'!A1

Reply to this Message

ilia - 12 Sep 2007 21:18 GMT

Oh you meant page header, not column header... sorry.

> > I am trying to get a header in excel to reference to a cell in a different
> > sheet. Is that possible? Thanks!
[quoted text clipped - 3 lines]
>
> ='Sheet2'!A1

Reply to this Message

Karissa - 12 Sep 2007 21:38 GMT

I do mean page header, sorry I wasn't clear. Does anyone know how to do that?

> Oh you meant page header, not column header... sorry.
>
[quoted text clipped - 5 lines]
> >
> > ='Sheet2'!A1

Reply to this Message

Bernard Liengme - 12 Sep 2007 22:19 GMT

Only with VBA as in my first message.

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

>I do mean page header, sorry I wasn't clear. Does anyone know how to do
>that?
[quoted text clipped - 9 lines]
>> >
>> > ='Sheet2'!A1

Reply to this Message

Karissa - 12 Sep 2007 22:56 GMT

Thank you, I really appreciate your help!

> Only with VBA as in my first message.
> >I do mean page header, sorry I wasn't clear. Does anyone know how to do
[quoted text clipped - 10 lines]
> >> >
> >> > ='Sheet2'!A1

Reply to this Message