| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I use worksheet data in headers?
I want to take information contained in one worksheet and use it in the
header of another spreadsheet. When I'm in the header setup, I can't access any cells or defined names. I figure there must be some way to do this in a macro. Any ideas? The example would be tying customer names to their ID numbers in a report generated from sales data (i.e., statements). |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I use worksheet data in headers?
Maybe this site will help you
http://support.microsoft.com/kb/273028 "dmanflan" wrote: I want to take information contained in one worksheet and use it in the header of another spreadsheet. When I'm in the header setup, I can't access any cells or defined names. I figure there must be some way to do this in a macro. Any ideas? The example would be tying customer names to their ID numbers in a report generated from sales data (i.e., statements). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I switch headers within a worksheet | Excel Discussion (Misc queries) | |||
| creating repeating headers in a worksheet | Excel Discussion (Misc queries) | |||
| headers in worksheet | Excel Worksheet Functions | |||
| Can custom headers be linked to a cell in the worksheet? | Excel Discussion (Misc queries) | |||
| Headers on every worksheet | Excel Worksheet Functions | |||
Hybrid Mode
