Header Help

[billykiller05]

Is there a way to link a header or a portion of a header to a specific cell?

[NBVC]

Go to Insert|Hyperlink and choose Place in this Document from the Link to area. Then choose the cell reference and sheet references.

[billykiller05]

How do I insert a Hyperlink into a header?

[NBVC]

So my previous reply was incorrect? What exactly do you mean then?

[billykiller05]

I do not know if it is incorrect or not. I am new to excel. I would like to be able to key a month and an year in cell A1 and have that update each of my headers. I have 12 sheets with headers that I would like this to update. I cannot always use today's date so I would like to be able update the headers another way with a date of my choice.

[NBVC]

So if in Sheet2 to Sheet "whatever" you typed =Sheet1!A1, is that what you mean?

I am not quite understanding what you mean by updating headers.

[billykiller05]

Each of my headers will be like Jim to Bob mm yyyy 56466, Bob to Steve mm yyyy 56466, and so forth. I would like to be able to enter 06 2008 in one cell in the workbook and have all of the headers for each page update instead of going into each header and manually updating each one. (trying to be lazy) Next month I could enter 07 2008 (or another month and year) and the headers would update.

[NBVC]

Then insert something like:

=Text(Sheet1!A1,"mm yyyy") within your text string...

eg. "Jim to Bob "&Text(Sheet1!A1,"mm yyyy")&" 56466"

where Sheet1!A1 is your input cell

[billykiller05]

I copied from your reply and this is what I got. "Jim to Bob "2:32 PMText(Sheet1!A1, "mm yyyy") & " 56466".

[NBVC]

Did you put an = sign in front?

="Jim to Bob "&Text(Sheet1!A1,"mm yyyy")&" 56466"

And there should be a date in Sheet1!A1.

[billykiller05]

It returns the same information as before.

[NBVC]

I'm not sure how you get this: "2:32 PM" to replace the "&"?

Maybe you can attach your workbook sample?

[billykiller05]

Here is a test example of my file.

[NBVC]

Oh so you want to update the Sheet Names with your dates?

well, that'll require VBA...

Hopefully someone can chime in and help you on that....

[billykiller05]

No not the sheet names just the custom header for each sheet.

[NBVC]

Boy, I hope we are not still misunderstanding each other... see attached...

[billykiller05]

What is in row one is what I am needing but is there any way to update this into the cutom header you see on Page Setup.

[NBVC]

Again, only through VBA intervention...

I am not a VBA person though...