Hopefully my last question. The macro works great! Thanks! But I noticed that it disabled the rows marked employee information from repeating on each page. Not a problem - but I at least need each footer to to have a field that automatically shows the employee name on each page. How do I create this custom footer field?