G Guest Sep 12, 2007 #1 I am trying to get a header in excel to reference to a cell in a different sheet. Is that possible? Thanks!
I am trying to get a header in excel to reference to a cell in a different sheet. Is that possible? Thanks!
B Bernard Liengme Sep 12, 2007 #2 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
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
I ilia Sep 12, 2007 #3 I am trying to get a header in excel to reference to a cell in a different sheet. Is that possible? Thanks! Click to expand... Supposing the cell on a different sheet is A1 and the different sheet itself is called Sheet2, use this formula: ='Sheet2'!A1
I am trying to get a header in excel to reference to a cell in a different sheet. Is that possible? Thanks! Click to expand... Supposing the cell on a different sheet is A1 and the different sheet itself is called Sheet2, use this formula: ='Sheet2'!A1
G Guest Sep 12, 2007 #5 I do mean page header, sorry I wasn't clear. Does anyone know how to do that?
G Guest Sep 12, 2007 #7 Thank you, I really appreciate your help! Bernard Liengme said: Only with VBA as in my first message. -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email Click to expand...
Thank you, I really appreciate your help! Bernard Liengme said: Only with VBA as in my first message. -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email Click to expand...
