Excel headers
 

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

Excel headers
 

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

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

Excel headers
 

On Sep 12, 3:34 pm, Karissa wrote:
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

Excel headers
 

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

On Sep 12, 4:18 pm, ilia wrote:
On Sep 12, 3:34 pm, Karissa wrote:

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

Excel headers
 

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

"ilia" wrote:

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

On Sep 12, 4:18 pm, ilia wrote:
On Sep 12, 3:34 pm, Karissa wrote:

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

Excel headers
 

Only with VBA as in my first message.
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Karissa" wrote in message
...
I do mean page header, sorry I wasn't clear. Does anyone know how to do
that?

"ilia" wrote:

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

On Sep 12, 4:18 pm, ilia wrote:
On Sep 12, 3:34 pm, Karissa wrote:

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

Excel headers
 

Thank you, I really appreciate your help!

"Bernard Liengme" wrote:

Only with VBA as in my first message.
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Karissa" wrote in message
...
I do mean page header, sorry I wasn't clear. Does anyone know how to do
that?

"ilia" wrote:

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

On Sep 12, 4:18 pm, ilia wrote:
On Sep 12, 3:34 pm, Karissa wrote:

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