Hello,
I have about 6 sheets and each has a Page Header
Example,
Total Items - Period X, 2007 YTD, I'm trying to input an actual number in
the X,
Example, Total items - Period 12 2007 YTD. Its time consuming going
manually into each sheet an replace the X with the current Period.
Is there a way I can do this with a Macro?

I really would appreciate any info I can get
Thank you,
J