If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can a header & footer be copied to a new file?
Any help on the aforementioned would be much appreciated! Thanks
|
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|