Variable in Worksheet Header

[shdawson]

Hi,

I need to put some different information in the various worksheets of a workbook I have. Things like attributes of the reports. Like...what department it is for, or something like that.

Can a person reference a cell in a header? Say I put that necessary info in a cell on worksheet INFO. In cell A4, I put...Human Resources. Something simple like that.

Please advise.


Thank You,
S

 

[GlennUK]

No. But you can put code into a Before Print event to generate headers from cell contents. What information do you want in headers? Is this going to be different for each sheet? If so, will the information be in the same cell location?

 

[shdawson]

Just text.

Something simple that will reference a cell and put that info in there. Things like

HR Report
PMO Status Update


...text strings like that.


THanks,
S

 

[GlennUK]

An explanation of using the Before Print event is here:

http://www.mrexcel.com/articles/event-macro-to-change-excel-header.php

Tweak it for your needs.

 

[shdawson]

Thank you very much.


Kindly,
SHD