Can a header & footer be copied to a new file?




Bernard Liengme

Sheet1 in Book1.xls has a header and foooter
Book2 is also open
Using Windows/Arrange in XL2003 or View | Arrange All in XL2007, the two
files are tiled so both can ve seen
Holding down CTRL, I drag the Sheet1 tab of Book1 to the sheet tab area of
If Book2 already had a Sheet1, it now has Sheet1(2)
The new sheet in Book2 has the same header & footer as that in Sheet1 of
But if you are goint to do this weekly, a VBA subrountine would be neater
best wishes

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question