Hi, I am building a template to be used by multiple teams. I would like
them to enter their team name once in the first worksheet of a multi
sheet workbook. I would like to have the team name appear in the header
and footer of each worksheet also without having to modify the header or
footer manually. Is there a way to do this?


--
tmacke
------------------------------------------------------------------------
tmacke's Profile: http://www.excelforum.com/member.php...o&userid=16817
View this thread: http://www.excelforum.com/showthread...hreadid=532985