I'm a novice-intermediate level Excel user. I use Excel for scheduling employees. Each week, a new workbook is created with the weekly schedule. Each week, I change the Footer of Worksheet1 to reflect the new info, for example "Office Schedule 01/29/12 - 02/04/12." That Footer of Worksheet1 should also be the Header of Worksheet2 and Worksheet3. When I change the Footer of Worksheet1 for the next week's schedule, I want the Headers of Worksheet2 and Worksheet3 to change to match the Footer of Worksheet1 using some sort of macro.
Please let me know if this is possible and I appreciate any assistance.
Thanks,
Dan D.