I have a worksheet designed to print a certain kind of document. In this case
it is gross composition for a product. There are several different products
which fit into this template I have designed. The amount of information in
this document varies, which gives me a problem with the bottom of the
document. I want a prdoct specific text at a fixed point at the bottom. The
footer option will do that, but it will not allow me to place cell
information in it. Using VB will only put in the correct text when I open the
document. What I would like to do is having the footer change "realtime" when
the cell, that it refers to, changes.

Anyone know if this is possible?