Create header/footer txt file and link to Excel worksheets
Hi all,
I work for a company that typically has very large and long engagements. Many reports/schedules/analysis spreadsheets are created throughout obviously. Each case usually has its own custom headers/ footers specific to that case. Although they can change numerous times. Is there a way to create a simple txt file with a header and footer, and link the excel doc to that so it reads that file everytime it opens and creates its headers/footers. This would help so if there is a change to a header/footer layout during the case, I could simply edit that one file that every spreadsheet is linked to, oppossed to opening all files. Thanks for your help in advance. --Camby |
All times are GMT +1. The time now is 09:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com