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
|