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

B

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
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
 

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

Similar Threads

PowerPoint Separate lines (line break) - PowerPoint Footer 1
Can a header & footer be copied to a new file? 1
Can I copy header & Footer into new file? 1
Headers and Footers - How to copy? 1
How do i import header and footer from diferent XLS file? 1
Formulae in headers or footers 2
Problems with Headers/Footers 1
No More New Fonts May Be Applied To This Work Book 2

Top