View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AFD at FONO AFD at FONO is offline
external usenet poster
 
Posts: 1
Default How do I copy the contents of a cell into a footer

Headers and footers consist of three parts - left, center, and right. In the
application I am currently working on I want to put a standard revison number
in the left part of the footer which will appear on all worksheets. In the
right section I want to put a page number of the form <section-&[Page]. Can
I put the revison number in a cell on the first worksheet and reference it in
all the footers? If so, how do I do it? Note - the margins are not the same
across all worksheets.