Is there a way to set headers/footers to auto populate to a set format? For
example on each page the file name would appear at the top and the worksheet
name would appear at the bottom of each page without having to set each one
individually.

thanks
--
Kathleen