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).

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).