On July 10, 2005 11:48 am, Olin Lathrop wrote:
> John Pearson wrote:
> > Is there a real simple way to get Excel to automatically copy the
> > contents of a cell to another cell every time the first cell is
> > updated or changed.
>
> How about make the second cell a summation that includes only the
> first cell?

Let us suppose, the cell is A5 and you want to copy it to cell H2.
In cell H2 enter in the formula
=A5

Olin's suggestion works as well, but fills H2 with the formula
=SUM(A5:A5)

if you pick up a book at the library for LOTUS 123 or QUATTRO, or some 
other older spreadsheet, they tend to show these old-style formulas.
The old formulas are a bonus since they are transferable to competing 
spreadsheets while VBA is not transferable beyond Excell.
-- 
http://www.piclist.com PIC/SX FAQ & list archive
View/change your membership options at
http://mailman.mit.edu/mailman/listinfo/piclist