PC Review


Reply
Thread Tools Rate Thread

Can I use worksheet data in headers?

 
 
dmanflan
Guest
Posts: n/a
 
      15th Nov 2008
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 With Quote
 
 
 
 
Mike
Guest
Posts: n/a
 
      15th Nov 2008
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
headers in worksheet =?Utf-8?B?YWFtaXI=?= Microsoft Excel Worksheet Functions 4 12th Nov 2006 07:04 PM
Headers on every worksheet =?Utf-8?B?bG9ja3dvb2QzMw==?= Microsoft Excel Worksheet Functions 1 8th Jul 2005 07:17 PM
How to set Column headers as row headers in Data grid control =?Utf-8?B?VlIgUmF2aW51dGhhbGE=?= Microsoft Dot NET Framework Forms 1 3rd May 2005 12:25 AM
Worksheet headers Peter B Microsoft Excel Worksheet Functions 3 9th Jan 2004 04:36 AM
Worksheet Headers/Footers KarinP Microsoft Excel Misc 1 9th Oct 2003 08:42 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:25 PM.