ExcelBanter - I need my footer to print with 7 different names.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - I need my footer to print with 7 different names. (https://www.excelbanter.com/excel-discussion-misc-queries/118478-i-need-my-footer-print-7-different-names.html)

nay

I need my footer to print with 7 different names.

I am trying to print n copies of the same worksheet but with different footer
names. For example, 1st copy with footer name "Judge", 2nd copy with footer
name "Timer" and so forth until I have all n names used up.

Any help will definitely be appreciated.
--
nay

All times are GMT +1. The time now is 08:59 AM.