Hi,

Is it possible to get the contents of a cell to appear in a footer?

If so, what do I enter into the custom footer box if I want, say, the contents of cell B1 on sheet1 to appear in the footer of pages printed from Sheet2?

I am using Excel 2003.

Thanks in advance.