copy changing data within a spreadsheet automatically


Posted by bud on December 14, 2000 2:17 PM

Is it possible to have the last entry in a column automatically copied to another part of the spreadsheet. The column is constantly being added to but the numbers are not always larger or smaller.
Thanks



Posted by Tim Francis-Wright on December 15, 2000 8:30 AM

Check out Ryan's answer to a similar question earlier this year:

(It involves a very short user-defined function.)
2768.html