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

Section and Page numbering 0
Space at end of multi page list to accommodate new entries 1
Automatically insert "Continued" in footer based on existing STYLEREF 2
(headers & footers Issue) I have 2 even pages back to back!! 1
I need help with removing the header & footers on the last page in word 2010 7
Project Professional 2016 - Headers and footers not showing up in print preview & printed document 2
New computer, how do i move outlook 365 ENTIRELY? 0
Can a header & footer be copied to a new file? 1

Top