ExcelBanter - How to incorporate cell data in a worksheet header

John,

What you're looking for can be done through VBA, but nothing else.

You can create a procedure that sets the header of the active sheet (or all
of them) based on just about anything you like. Here is a sample of
something I recently did which sets the footer to include specific
information from the workbook.

Worksheets("Quote").PageSetup.LeftFooter = _
"&""Trebuchet MS,Bold Italic""&12Fax Back to: " & Range("SettingsFax") &
". Attn: " & Range("SalesPerson") & "."

So the worksheet "Quote" gets its Left Footer set to something that looks
like:
Fax Back to: 123-456-7890. Attn: John Doe.

The Range("SettingsFax") simply refers to a named range somewhere on the
worksheet. This is usually better than referring to just C12, since cells
move around.

I hope that helps.

--
-David D

"John Bennett" wrote:

I need to create a Worksheet Header which incorporates numeric and textual
data contained in worksheet cells. Although this is a relatively straight
forward procedure in Lotus 123, I am unable to find a method in Excel (Office
2003).
Any suggestions would be welcome.

Regards,

John Bennett