Printing Headers

[Timmy Mac]

I have set up a spreadsheet to be used by some people I work with where they can input some variables to produce different results affecting what shows on several different worksheets.

However these worksheets have all different print ranges etc. What I want to be able to do is to enable a part of the header to reflect a name required for the variation of report that's done. The only way I can do this at present is to go and change it on each worksheet individually (if I group them together it exports all the othe print settings of the sheet I'm on to the other sheets).

Is there any way I can set part of the Header up so it refers to the contents of a cell?

[teylyn]

Hi,

you can put something like this in a macro that you can attach to a button or run from the macro menu

Please Login or Register  to view this content.