Excel Data into PAge Header

[retseort]

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

[swatsp0p]

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

[retseort]

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.

[swatsp0p]

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.

[retseort]

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

[retseort]

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

[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