As I add numberic information to a number of worksheets I want the
consolidation sheet to be updated with the new total. I find that when I
have information going to the consolidation sheet then enter a new value in
the worksheet that the total of the column is not reflected in the
consolidation sheet. The consolidation sheet still shows the total that was
and is in the cell that was used for totalling in the first calculation. Can
I make the value shown in the consolidation sheet a "floating" cell from the
worksheet?