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.