Using Excel 2003. Trying to add up home accounts. Want to copy formulae from
one column to another. Can Excel do this automatically? eg =SUM(B20+C16)
to =SUM(C20+D16) to =SUM(D20+E16) where B, C and D are months, line 16
is the sub total and 20 is the total that I would like to carry through to
the next month. Do I have to keep inputting =SUM etc, or is there someway of
replicating this formula when the computer can change the letter of the
column automatically? Help!