Excel Data into PAge Header

[retseort]

Hello,

I need the following three capabilities. I seem to find them in bit
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 th
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 a
the header.

Thanks In Advanc

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

 

[swatsp0p]

You could use the "Print Titles" portion on the Page Setup>Sheet t
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 Luc

 

[retseort]

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

I would think someone else has wanted to do this

 

[swatsp0p]

I need it to print on all pages and all sheets and it does not seem t
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 sam
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 codin
in a macro.

Sorry I couldn't be of more help

 

[retseort]

Actually that is what I am looking for VBA coding Macro

 

[retseort]

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

 

[swatsp0p]

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

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

 

[retseort]

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