Excel Data into PAge Header

  • Thread starter Thread starter retseort
  • Start date Start date
R

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
+-------------------------------------------------------------------
 
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
 
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
 
retseort said:
I need it to print on all pages and all sheets and it does not seem t
do that.
Click to expand...

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
 
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
 
Back
Top