Fellow Monkeys -- I hope some of you can help me out.
After adding countless items into the data room for an acquirer, our clients management team decided they wanted to have a specific header and footer in each excel file.
Is there a way to add headers/footers across multiple workbooks? I'd like to streamline this process a little. Also, opening hundreds of files for no real reason sounds awful. Hope there is an answer...
| +216 | UBS Accused of Favoring H-1B Workers While Cutting U.S.-Born Employees | 51 | 13h |
| +109 | IB Energy Drink Tier List / Ranking | 72 | 21h |
| +103 | ONLY THESE BANKS OR YOU STRUCK OUT | 31 | 6h |
| +91 | PJT M&A Group Selection 2026 | 14 | 18h |
| +51 | Feedback for internship first desk at IBD BB - personal fit, "don't be too confident" | 29 | 20h |
| +46 | Firm Thinks I'm Lying About Offer | 18 | 10h |
| +31 | Stay at Weak Dealflow Team or Lateral? | 7 | 22h |
| +30 | Does BofA still pay its associates rat pellets? | 15 | 20h |
| +26 | Rogo AI | 6 | 6h |
| +22 | Indiana University Fraternity Pipelines | 13 | 17h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
How many workbooks is it?
You can group the sheets and apply the header and footer automatically, just remember to ungroup the sheets before you save.
Do you know vba? I am guessing there is a way to batch automate it if everything is in the same folder but I haven't done it before.
Its roughly 400 files.
I am starting to teach myself VBA but don't know it well enough yet.
Try following these, there is no summary I can type that will be more useful than a video.
https://www.youtube.com/watch?v=9tOOa1ll3bEIf you don't mind clicking 400 files and the videos didn't work, this could work.
Lets try a test, Make a new folder for me and copy a small number of workbooks to it. Then change the header and footer in one active book and run this;
"Sub CopyHeaderFooter() Dim PS As PageSetup, WB As Workbook, WS As Worksheet Set PS = ActiveSheet.PageSetup For Each WB In Workbooks For Each WS In WB.Worksheets With WS.PageSetup .LeftHeader = PS.LeftHeader .CenterHeader = PS.CenterHeader .RightHeader = PS.RightHeader .LeftFooter = PS.LeftFooter .CenterFooter = PS.CenterFooter .RightFooter = PS.RightFooter End With Next Next End Sub"
You better quote this to get the spacing right just in case I didn't do it correctly.
Thank you for the insight! I will work on my VBA skills. For this task, I sucked it up and...had an intern do it.
Someone should make a plug-in for this though, I feel like it could be pretty useful.
Ipsam ipsum laudantium blanditiis soluta deleniti. Aut est laboriosam deserunt est nihil facere hic. Doloremque soluta repudiandae nobis architecto aut est.
Reiciendis quo at qui dolores quidem consequatur placeat. Fugit molestiae sapiente id temporibus ut. Dolores consequatur sequi voluptatibus et. Sequi blanditiis ducimus aut ea. Distinctio cum voluptas architecto a esse illum similique.
Assumenda qui et dolor aut iste. A architecto doloremque ipsa. Voluptas eaque eligendi et fugiat nobis laborum sapiente.
Qui sunt ea repellendus. Exercitationem voluptas nobis et voluptas. Magni ut nemo consectetur fuga. Sed aperiam explicabo eligendi alias maxime vel. Dolorum eos nihil at earum error aliquid. Quis distinctio veniam autem.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...