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

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
Book2
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
Book1
But if you are goint to do this weekly, a VBA subrountine would be neater
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"A little stuck" wrote in message
...
Any help on the aforementioned would be much appreciated! Thanks :)