Excel Query

Misticles

I am doing some reports, although the outline is the same the content/dats change.

In particular, dates in the headers.

For example, one report will have 31 OCTOBER, when I go in the following month, I copy the basis of the report but I have to go through the header of every page and manually custom the header and change it to 30 NOVEMBER.

If I try to change all of them at once, the same header gets applied to every page which is no good to me as they all have different ones yet include the date.

Is there any way of doing it all at once without the heading of the initial page being applied.

Thanks

bhickey

I've read that a few times and to be honest, I can't make out what you're trying to do. Can you have another go at explaining it, or even attach a sample?

homer911

A Macro?

angelfire9

Put the dates you want on the tabs (instead of sheet 1/2/3) and use the tab option in the header?

FSL

You could just change the date cell on every sheet to point to a cell on an additional sheet, you then only need to change the date on the additional sheet.

-Chris-

I'd use Crtl+H, and then replace /10/10 with /11/10. It should change every October to November