Nope, don't think you're an idiot. Just hadn't seen that option before.
There are a ton of dark corners in Excel that I haven't seen and I've been
working with it since Office 4.5 and have MOS Expert cert in it and a couple
of other Office Apps. No one can know everything about any of these. The
real gurus quite often live and breathe just one product.

Glad I was able to assist.

"Pamela Martin" wrote:

I know you must think I'm an idiot, but I just never saw that option. It
does what I need. Mahalo.

"JLatham" wrote:

Can't you use Edit | Move/Copy Sheet with the Make Copy option ticked? And
then make whatever changes you need to?

One other possible solution if the Headers/Footers are standard enough - and
it sounds like they are. Use Macro | Record New Macro to record a macro of
you defining the header/footer on a sheet as you need them to be. Save that
macro in your Personal XLS workbook (it's an option during the recording
process). By being in your Personal.xls workbook, it will always be
available to you, so when you want a sheet to have that header/footer, you
just run the macro while the new sheet is selected.

"Pamela Martin" wrote:

Thank you, but I can't group, because the sheets are only made one at a time.
Each week I copy an old report to a new sheet to update some data, but the
print setup never copies with it(That is the heading and footer), so I have
to put the same information in each time.

"Pamela Martin" wrote:

I tried using Views - but it didn't take put the Heading or footer on the
next worksheet.