Is it possible to set the header and footer in an Excel file so it is
repeated across the worksheets contained within the file. i.e. Each workbook
contains 3 worksheets. I set the header and footer info on worksheet 1.
However I have info on Worksheets 2 and 3 and the header and footer info
doesn't copy across. I have to manually enter them. Can you help. Is there an
easy way to do this?


Regards

Darren M