Hello,

I need the following three capabilities. I seem to find them in bits
and pieces but nothing that will work the way I need it.

1. Ability to copy a range (e.g. A1:J5) and use the data copied as the
header

2. #1 above should print on all sheets, all pages

3. The Header should update if the date in Range A1:J5 is updated.
(optional)

ANYTHING you can give me will help.

I have attached a sample of the data I am working with that I need as
the header.

Thanks In Advance


+-------------------------------------------------------------------+
|Filename: excel issue.gif |
|Download: http://www.excelforum.com/attachment.php?postid=3944 |
+-------------------------------------------------------------------+

--
retseort
------------------------------------------------------------------------
retseort's Profile: http://www.excelforum.com/member.php...o&userid=24690
View this thread: http://www.excelforum.com/showthread...hreadid=478930

You could use the "Print Titles" portion on the Page SetupSheet to
print rows 1:5 on all pages (Rows to repeat at top).

Check it out. It may just be what you are looking for!

Good Luck


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=478930

Thanks, I was aware of that but I need it to print on all pages and all
sheets and it does not seem to do that. I also think from a user
perspective that anything that will operate as a header function does
would be preferable.

I would think someone else has wanted to do this.


--
retseort
------------------------------------------------------------------------
retseort's Profile: http://www.excelforum.com/member.php...o&userid=24690
View this thread: http://www.excelforum.com/showthread...hreadid=478930

retseort Wrote:
I need it to print on all pages and all sheets and it does not seem to
do that.

It is odd that it (Print Titles) *doesn't* print on all pages, because,
by design, that is exactly what it is supposed to do (print the same
row(s) at the top of each page). Can you explain exactly what it *is*
doing?

To pull data from cells and place in the header will require VBA coding
in a macro.

Sorry I couldn't be of more help.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=478930

Actually that is what I am looking for VBA coding Macro.


--
retseort
------------------------------------------------------------------------
retseort's Profile: http://www.excelforum.com/member.php...o&userid=24690
View this thread: http://www.excelforum.com/showthread...hreadid=478930

Pushing this to top of page...again. Hoping for an expert


--
retseort
------------------------------------------------------------------------
retseort's Profile: http://www.excelforum.com/member.php...o&userid=24690
View this thread: http://www.excelforum.com/showthread...hreadid=478930

retseort Wrote:
Pushing this to top of page...again. Hoping for an expert

**OUCH** Where to find an 'expert'?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=478930

Bruce,

I certainly wasn't implying that you weren't an expert. There are no
word to express the appreciation to you and everyone who has given me
and others assistance.

Sincerly,

Dan


--
retseort
------------------------------------------------------------------------
retseort's Profile: http://www.excelforum.com/member.php...o&userid=24690
View this thread: http://www.excelforum.com/showthread...hreadid=478930