Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to incorporate cell data in a worksheet header
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I reference data from one worksheet to another using combob | New Users to Excel | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
macro help | Excel Discussion (Misc queries) | |||
Cell Reference Math | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions |