The header/footer were in each workbook. Instead of 3 workbooks each with 1
sheet, we decided to place them in one workbook with three sheets. So how
can I get the header/footer from the other two workbooks into one?

"Earl Kiosterud" wrote:

Roberta,

If you've copied the entire sheet (Right-click its tab - Move or Copy),
instead of copy/pasting the cells within the sheet, all the Page Setup
stuff, including the custom header, should come with it.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Roberta" wrote in message
...
I have 3 worksbooks that should have been 3 worksheets w/in a workbook. I
have no problem of copiing and pasting the data into one workbook but is
there a way to copy the customer header/footer into the workbook for each
sheet?