Header to Match Worksheet Cell or Cells?

Hi,

I'm curious to know if there's a way to have the header to match a cell or (merged) cells, without having to copy & paste.

For example,

If I have a multi-sheet drawing & I have the title of my document as, "Project 1", can I also insert this into the worksheet headers to (without copying or pasting). Primary reason that I"m asking is that I also apply dates & either will forget to update the date in the header or someone else will with the template created.

If this is possible - how?



Thanks

I have a worksheet named "Presentation". On that sheet, I've added the information I want for the header & footer in the range O2:Q3 (outside the print area for the sheet). I use this code to update the header/footer info with whatever is in the range:

Please Login or Register  to view this content.

Cheers,

Hi ConneXionLost,

Thanks for the info. Where does the code go & is there a macro that needs to be ran to update? Do you happen to have an example file?

Thanks